Re: [Firebird-odbc-devel] Driver issues

[Martijn T. <m.t...@up...>]

Hello Alexander,

>> It returns from SQLExecute instantly now, so that's good.
>>
>> But when going through all rows, it still takes a lot of memory, as
>> if all blobs are instantiated in memory. What could cause this?
>>
>>   
> It seems that the client application caches the data. If the cursor type 
> is FORWARD ONLY the driver should not caches the prior records.

I've changed the call so that the components use an ODBC cursor
type of FORWARD ONLY, yet, I can still see the memory use
increase when working with blobs and cycling the resultset.

I've forwarded this issue to the component creators too, perhaps 
you can check as well?

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com