How can I optimize the speed of the IBCQUERY control?

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
scorpion
Posts: 2
Joined: Wed 11 Jul 2007 15:23

How can I optimize the speed of the IBCQUERY control?

Post by scorpion » Wed 11 Jul 2007 15:48

Hello to all, I have been testing IBDAC controls and they are really good, but wanted to know if a there's way to optimize the selects, deletes and the insertions to data base using IBCQUERY. Maybe I can disable some option that improve its speed. Thanks!

Alex
Posts: 655
Joined: Mon 08 Nov 2004 08:39

Post by Alex » Thu 12 Jul 2007 08:39

Please pay attention to the "Increasing performance" article in the IBDAC help.
Also you can achieve a little performance gain by setting IBCQuery.Options.StrictUpdate to False.

Post Reply