Hi,

I have a table with 30k rows. I use the Firebird API to retrieve the
rows one by one. The fetching performance is good if I don't fetch
Blob fields.

I fetch rows with blob fields as follow:

repeat
isc_dsql_fetch(...);
isc_dsql_open_blob(...);
isc_dsql_blob_info(...);
isc_dsql_close_blob(...);
...
until finish

It tooks about 9 seconds to fetch 30k Blobs. It is too slow. I try
the Borland's DBX drivers, and it able to fetch 30k blob fields in
just 2 seconds.

Is there any good ways to solve this?

Thank you.