IBDAC How can I improve the speed?

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
softdestek
Posts: 7
Joined: Tue 01 May 2012 06:57

IBDAC How can I improve the speed?

Post by softdestek » Thu 03 Oct 2013 17:10

There are 120 thousand records in the table. There is one in the blob field of the table ..
IBCQuery1 select the speed? 0:0:20:438
Why are you so slow?

IBQuery1 select the speed? 0:0:01:532
IBDAC How can I improve the speed?
Top
AndreyZ

Re: IBDAC How can I improve the speed?

Post by AndreyZ » Fri 04 Oct 2013 06:52

To solve the problem, you should set the DeferredBlobRead option to True. DeferredBlobRead is used for fetching BLOB values when they are explicitly requested. You can find more information about the DeferredBlobRead option in the IBDAC documentation.
Top
Post Reply

Return to “InterBase Data Access Components”