Devart Forums

Hi,
I have a TUniQuery Component to connect to a remote server(thru Internet), to read about 500-600 records.

When a blob flied is included on the select statement the query takes several minutes to execute but if the blob field is not included on the select the query executes in a few seconds. How can I avoid this and have access to the blob field?

Using a TIBQuery(from IBX package), I have no performance issues no matter if the blob field is included on the select statement.

Thanks in advance,

Omar Zelaya

Hi,

So the Devart ream doesn’t have a response for something this simple, I have paid for product that has a really serious bug that I could come around by just simply use the libraries that are already included on RAD Studio?

Looks like I have wasted $200...cool thanks...fool me once...Shame on you...fool me twice…shame on me…

Omar Zelaya

Hello,

Try to search the forum. I read some posts about this problem a time ago. As I remember there are the options to disable downloading blob contents.

Regards
Michal

To solve the problem, you should set the DeferredBlobRead specific option to True. DeferredBlobRead is used for fetching BLOB values when they are explicitly requested. Here is a code example: