Devart Forums

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?

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

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

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

Hope this function works soon
fall guys

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.

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.