🚀 go-pugleaf

<Gerard Vanderveken Ghia_no_spam.pi.be> wrote in message 
news:43256774$1@newsgroups.borland.com...
>
> Hi,
> I have a table with 200 000 entries (key number and data). Each morning I 
> receive a file with records and I need to verify with the database table 
> if keys are added or deleted, and if the data was changed on the other 
> records.
> This process takes a very long time (2 hours). But I noticed that 2 times 
> 40 minutes are used in the fetching of the records.
> I timed a fetchall. Also IBconsole takes this long time (Table - data - 
> scroll bottom) to load the complete table.
> I tried to speed up by enlarging the bufferchunks to 50 000, but no avail.
> The CPU (800MHz) stays always under 1%. What is it waiting for?It makes no 
> difference on running the program and database on the same or different 
> PC.
> What can I do to speed up this and why isn't there more CPU time used?

If possible, try reading the dataset without caching the results 
(Unidirectional=TRUE).  A lot of CPU time is spent reallocating memory for 
buffers when caching lots of results.

Dan