Perfomance issue with select and blob field

[ozelaya2010]

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

[ozelaya2010]

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

[FCS]

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

[AndreyZ]

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:

Code: Select all

UniQuery.SpecificOptions.Values['DeferredBlobRead'] := 'True';