Subject RE: [ib-support] Fetching records and CPU utilization
Author Thomas Steinmaurer
Hi Set,

> I once had a problem where my TIB_Cursor (don't think I used a TIB_Query)
> seemed to 'restart' after having fetched a lot of records and things came
> to a crawl (it would start off fetching e.g. 80000 records and then the
> client would wait until those 80000 records were fetched again before
> proceeding and after possibly another 10 or 20 thousand rows (continuously
> decreasing for each iteration) restart again...). I don't quite remember
> how things got solved, but I think I tried to disable CallbackInc by
> setting it to -1 or increasing CallbackInitInc beyond the number of rows I
> wanted to return (I thought about setting AutoFetchAll to true, but doubt I
> did that).

Ah, this looks similar to mine. Though, I've already set CallbackInc to -1.

I don't know if this is related to IBO (my application, InterBase Workbench),
because with QuickDesk (using FIBPlus) I have the same problem.

Thanks for your comments!


Thomas.