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: 109
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!

faulknernolan
Posts: 2
Joined: Wed 20 Jul 2022 08:41

Re: Does IBDAC 8 support Firebird 4 batch execution?

Post by faulknernolan » Sun 24 Jul 2022 14:17

Hope this function works soon
fall guys

divorcecoloured
Posts: 1
Joined: Mon 25 Jul 2022 08:06

Re: Does IBDAC 8 support Firebird 4 batch execution?

Post by divorcecoloured » Mon 25 Jul 2022 08:08

The applies to Update and Insert inquiries (i.eoctordle, there will be no update/insert returning), and it can be used to combine a number of different queries into a single action. This can be used to reduce interactions between clients and servers and to speed up the updating and inserting of data on servers.

pipiolo
Posts: 1
Joined: Sat 22 Oct 2022 10:07

Re: Does IBDAC 8 support Firebird 4 batch execution?

Post by pipiolo » Sat 22 Oct 2022 10:08

It's a known problem about IBX and UTF8 for Firebird.
I heard about a patch (not embarcadero) for this but I don't find it.
Other soltuion is to switch from IBX to FIBPlus, IBDac or UIB.

Post Reply