BorlandTalk.com

Laércio Amici · Guest

Hello,

I´m making a general form to do a grid to user, that makes general
queries over tables on the database. To do this, I´m using
SqlConnection, SqlQuery, Datasetprovider and ClientDataset.

The problem is that the Clientdataset do a cache of all records into
memory, and that a long time to do this, and use a lot of memory in this
operation (i.e.: a table with over 57000 records).

In a grid, if the user press Ctrl+End, a disaster occurs. It takes over
5 minutes to do the all operation.
Is there another method to do this kind of query/grid without exhaust
all memory resources and take it in a short time?

D7 Entreprise
Oracle 8i

Using ClientDataset.packetrecord = 1000.

Thanks in advance,

Laércio S Amici
[email]lamici (AT) ig (DOT) com.br[/email]

Bill Todd · Guest

Please do not multipost or cross post your messages. It violates
Borland's guidelines for using their newsgroups and wastes everyone's
time. Please post one message in the most appropriate newsgroup.

ClientDataSet is intended for use with small result sets. You should
prompt the user for some selection criteria that you can use in the
WHERE clause of your SQL statement to limit the number of records
returned.

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)