Devart Forums

Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart
https://forums.devart.com/

IBDAC How can I improve the speed?

https://forums.devart.com/viewtopic.php?f=24&t=28046

Page 1 of 1

IBDAC How can I improve the speed?

Posted: Thu 03 Oct 2013 17:10
by softdestek
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?

Re: IBDAC How can I improve the speed?

Posted: Fri 04 Oct 2013 06:52
by AndreyZ
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.
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/