Long Row in a query

[Shahine]

Hi..
I have a table with Long Row field.
Querying this table over a 576kbps link is quite slow, is there anything I can do to speed up the query?

This table does not contain many records (100 Max). The Long Row field is used to store a Report-Builder report template, and they are typically 60K-1Mb (although 1Mb is rare).

Many Thanks.
Shahine Ghanbarzadeh
Compucorp Ltd..

 

[Marco Kalter]

The best way to optimize this is to remove the Long Raw from the query, and to fetch it on demand, based on the primary key or rowid of the current record. This may require a little redesign of the application function, but for a slow network it may be necessary to trim down the result set as much as possible.

You can additionally set TOracleSession.QueryAllRecords to False, so that records are only fetched when needed.

------------------
Marco Kalter
Allround Automations