Article View: borland.public.cppbuilder.database.multi-tier
Article #1704Re: performance issues ClientDataSet
From: Jeff Overcash (TeamB)
Date: Wed, 11 Aug 1999 00:00
Date: Wed, 11 Aug 1999 00:00
35 lines
1986 bytes
1986 bytes
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)
--
Technical Details
Message-ID:
<37B22E27.16841038@onramp.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<7os6rs$cq71@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcd2b,24599ba173f48552 X-Google-Attributes: gidfcd2b,public From: "Jeff Overcash (TeamB)" <overcash@onramp.net> Subject: Re: performance issues ClientDataSet Date: 1999/08/11 Message-ID: <37B22E27.16841038@onramp.net> X-Deja-AN: 511676560 Content-Transfer-Encoding: 7bit References: <7os6rs$cq71@forums.borland.com> X-Accept-Language: en Content-Type: text/plain; charset=us-ascii Organization: TeamB Mime-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.multi-tier