Does IBDAC 8 support Firebird 4 batch execution?

[frickler]

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]

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]

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]

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

[arterycontain]

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