🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #1703

performance issues ClientDataSet

#1703
From: jmcd
Date: Wed, 11 Aug 1999 00:00
20 lines
1263 bytes
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.
Technical Details
Message-ID: <7os6rs$cq71@forums.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,24599ba173f48552,start
X-Google-Attributes: gidfcd2b,public
From: "jmcd" <joanc@else.com.pe>
Subject: performance issues ClientDataSet
Date: 1999/08/11
Message-ID: <7os6rs$cq71@forums.borland.com>
X-Deja-AN: 511488633
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
Organization: Another Netscape Collabra Server User
X-MSMail-Priority: Normal
Newsgroups: borland.public.cppbuilder.database.multi-tier