🚀 go-pugleaf

> Several times I've looked for limitations on various things 
> and haven't found the place that documentation resides.
> 
> At the moment I'm looking for documentation on 
> TClientDataset (Win32 D2007) with regard to maximum record 
> count, max field sizes (TBlobField in particular), max 
> dataset memory usage, etc, etc.
> 
> I want to use the thing to collect/log information on a 
> temporary basis and possibly dump it to a cds file.   I'd 
> like to know how to tell I'm getting near limits.
> 
> Where is this information??

Not sure if it is documented anywhere.
I experimented with using clientdatasets back in D6.
I found that adding and querying slowed right down when
the number of records approached 10000. The records I was
using included string fields. It was probably quicker with
just numeric fields. And clientdatasets may have improved
since then.
However, the performance was not good enough for me,
and I went with an embedded firebird DB instead.

cheers,

Chris

"Chris Morgan" <chris.nospam@lynxinfo.co.uk> wrote in 
message news:479a7f93$1@newsgroups.borland.com...
>> Several times I've looked for limitations on various 
>> things and haven't found the place that documentation 
>> resides.
>>
>> At the moment I'm looking for documentation on 
>> TClientDataset (Win32 D2007) with regard to maximum 
>> record count, max field sizes (TBlobField in particular), 
>> max dataset memory usage, etc, etc.
>>
>> I want to use the thing to collect/log information on a 
>> temporary basis and possibly dump it to a cds file.   I'd 
>> like to know how to tell I'm getting near limits.
>>
>> Where is this information??
>
> Not sure if it is documented anywhere.
> I experimented with using clientdatasets back in D6.
> I found that adding and querying slowed right down when
> the number of records approached 10000. The records I was
> using included string fields. It was probably quicker with
> just numeric fields. And clientdatasets may have improved
> since then.
> However, the performance was not good enough for me,
> and I went with an embedded firebird DB instead.

Thanks for the reply.

What I'm doing won't involve 10k records so I should be fine 
there.  I'm using it to stuff away some blobs of various 
sizes and I wanted to see how close to the edge I was on 
those so I'd know whether to knock it off to keep from 
blowing the entire app.  I don't know if the TBlobFields are 
good for 200k or 200Gig (OK, I'm fairly sure it's not good 
for 200Gig<g>), likewise I don't know if there is a limit on 
the total database size or not.

Dan 

Hi Dan
I know its a while since you posted this but I gad a sudden urge to provide
a non answer ;-)
I did some development with TClientDataset some time ago and found it
incredibly slow when a significant amount of data was thrown at it.   I then
programmed my stuff using a simple TList the speed increase was incredible.
So if you're looking to heavily load a TClientDataset I would say DONT.

Regards
Paul

"Dan Barclay" <Dan@MVPs.org> wrote in message
news:4796d6b0@newsgroups.borland.com...
> Several times I've looked for limitations on various things
> and haven't found the place that documentation resides.
>
> At the moment I'm looking for documentation on
> TClientDataset (Win32 D2007) with regard to maximum record
> count, max field sizes (TBlobField in particular), max
> dataset memory usage, etc, etc.
>
> I want to use the thing to collect/log information on a
> temporary basis and possibly dump it to a cds file.   I'd
> like to know how to tell I'm getting near limits.
>
> Where is this information??
>
> Thanks,
> Dan
>
>
>

"Paul Hope" <paulhope@allcomm.co.uk> wrote in message 
news:47d9401c$1@newsgroups.borland.com...
> Hi Dan
> I know its a while since you posted this but I gad a 
> sudden urge to provide
> a non answer ;-)

It is much appreciated<g>.

> I did some development with TClientDataset some time ago 
> and found it
> incredibly slow when a significant amount of data was 
> thrown at it.   I then
> programmed my stuff using a simple TList the speed 
> increase was incredible.
> So if you're looking to heavily load a TClientDataset I 
> would say DONT.

Actually it will normally be very lightly loaded.  I just 
want to make sure that, even in unlikely events, it will 
degrade gracefully and not crash something.

It appears from the anecdotal specifications here that I'll 
be nowhere near a problem.

So, hopefully  your non answer is to a non problem<g>. 
Maybe.

Dan

>
> Regards
> Paul
>
> "Dan Barclay" <Dan@MVPs.org> wrote in message
> news:4796d6b0@newsgroups.borland.com...
>> Several times I've looked for limitations on various 
>> things
>> and haven't found the place that documentation resides.
>>
>> At the moment I'm looking for documentation on
>> TClientDataset (Win32 D2007) with regard to maximum 
>> record
>> count, max field sizes (TBlobField in particular), max
>> dataset memory usage, etc, etc.
>>
>> I want to use the thing to collect/log information on a
>> temporary basis and possibly dump it to a cds file.   I'd
>> like to know how to tell I'm getting near limits.
>>
>> Where is this information??
>>
>> Thanks,
>> Dan
>>
>>
>>
>
>