🚀 go-pugleaf

ClientDatasets really are not designed for that much data at once.  Have you
tried doing the filtering on the provider dataset's end?  That should improve it
some.  Also you might try asking this on the Inprise.public.midas group as the
experts (Dan Miser in particular) hang out.

jmcd wrote:
> 
> hi,
> 
> i have a two tiered app, and i want to turn it to multi-tier, before this i
> was testing the clientedatset component, and i found it very slowly with
> tables more than 10000 rows, y try to set packetrecord and fetchondemand to
> tune the app, but continue slow. for example i have a table of 50000 record
> and i want to search a specific record and position on it it takes about 15
> minutes to go to the record.
> 
> the point is that i have table with 10000 to 1500000 record, and some of
> these tables have a record size of 1.5k o 1k, so if client data set try to
> put all these record in memory i will need a lot of memory.
> 
> Does any one have the same problem? and how did you solve it?.
> 
> thanks in advance
> 
> Joan caceres
> electro sur este s.a.a.

-- 
Jeff Overcash (TeamB) 
      (Please do not email me directly unless  asked. Thank You) 
The mist crawls from the canal like some primordial phantom of romance
To curl, under the cascade of neon pollen.  While I sit tied to the phone
like some expectant father, your carnation will rot in a vase.
             (Fish)
--

Make your search with a TQuery on the server side of your multi-tier app and
put a TClientDataSet that holds result on the client side.

if you really need to have all the table data on client side you can mirror
your tables in a local paradox database, but you have to write code to copy
then update your local data.

--

-----------------------------------------------------------------
PIQUOT J�r�me
A. WOLFF SA
6, rue de la Gare
67120 ERNOLSHEIM/BRUCHE
FRANCE
e-mail: wolff@media-net.fr
http://www.media-net.fr/wolff
-----------------------------------------------------------------
jmcd <joanc@else.com.pe> a �crit dans le message :
7os6rs$cq71@forums.borland.com...
> hi,
>
> i have a two tiered app, and i want to turn it to multi-tier, before this
i
> was testing the clientedatset component, and i found it very slowly with
> tables more than 10000 rows, y try to set packetrecord and fetchondemand
to
> tune the app, but continue slow. for example i have a table of 50000
record
> and i want to search a specific record and position on it it takes about
15
> minutes to go to the record.
>
> the point is that i have table with 10000 to 1500000 record, and some of
> these tables have a record size of 1.5k o 1k, so if client data set try to
> put all these record in memory i will need a lot of memory.
>
> Does any one have the same problem? and how did you solve it?.
>
> thanks in advance
>
>
> Joan caceres
> electro sur este s.a.a.
>
>