Devart Forums

Hi,

Can You provide some information or examples (demo) how INSERT, UPDATE and DELETE batch operations works. I didn't hear that Firebird have some special API for that purpose.

Is it any better (faster) than TIBCLoader?
Where I can find some details about that?

Best Regards,
Macma

Indeed, there is no special API in Firebird to implement Batch operations. Batch operations and Loader in IBDAC use the same Firebird mechanisms for their own implementation. So the performance of multiple operations will be similar. Batch operations and Loader in IBDAC provide various interfaces for developer, who uses processing of prepared data. In case of using Loader, only data insert is available. Batch operations can be used not only for data insert, but also for updating and deleting, as well as for retrieving data in INSERT … RETURNING operators, that are supported by the Firebird server.

Samples of using Batch operations are available in our blog:
http://blog.devart.com/using-batch-oper ... nents.html

Thank You for the information. This is what I was looking for.

Best Regards,
Macma

Thank you for your interest to our products. Feel free to contact us if you have any further
questions about IBDAC.