🚀 go-pugleaf

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.
>
>