Does IBDAC 8 support Firebird 4 batch execution?

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
frickler
Posts: 37
Joined: Wed 04 Apr 2018 08:30

Does IBDAC 8 support Firebird 4 batch execution?

Post by frickler » Fri 24 Sep 2021 08:50

Firebird 4 introduces the Batch Execution interface. This applies to Update and Insert queries only (i.e. not update/insert returning) and can be used to batch up many separate queries to be executed as a single operation. This can be used to minimize the client/server interfaces and to optimize server update/insert times. It is done using parameters, not using EXECUTE BLOCK.

IBX for Lazarus supports this (in version 2.4.2), does IBDAC support this too?

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Does IBDAC 8 support Firebird 4 batch execution?

Post by ViktorV » Fri 24 Sep 2021 14:43

Hi!

Thank you for your request!

This support is not available in this poduct version. But we plan to add it in the next IBDAC release.
Should you have any other questions, do not hesitate to ask!

Thanks in advance,
Viktor

frickler
Posts: 37
Joined: Wed 04 Apr 2018 08:30

Re: Does IBDAC 8 support Firebird 4 batch execution?

Post by frickler » Thu 03 Mar 2022 08:31

ViktorV wrote: Fri 24 Sep 2021 14:43 This support is not available in this poduct version. But we plan to add it in the next IBDAC release.
Should you have any other questions, do not hesitate to ask!
So, was it added in 8.0.2? I don't see it mentioned in the revision history. Someone made a test [1] (in german) and found it 2 to 4 times faster compared to normal prepared inserts.



[1] https://firebirdforum.de/viewtopic.php?p=1253#p1253

pavelpd
Devart Team
Posts: 66
Joined: Thu 06 Jan 2022 14:16

Re: Does IBDAC 8 support Firebird 4 batch execution?

Post by pavelpd » Wed 09 Mar 2022 12:16

Hi there!
We do apologize for the delays in implementing this functionality.
We will add this support in one of the next builds!

arterycontain
Posts: 3
Joined: Mon 13 Jun 2022 02:11
Location: United States

Re: Does IBDAC 8 support Firebird 4 batch execution?

Post by arterycontain » Mon 13 Jun 2022 02:15

This only applies to Update and Insert inquiries (i.e., no update/insert returning) and may be used to combine many queries into a single action. This may be used to reduce client/server interactions and speed up server updates and inserts.


dordle

Post Reply