How INSERT, UPDATE and DELETE batch operations work

Macma · Post by **Macma** » Tue 15 Dec 2015 10:20

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

MaximG · Post by **MaximG** » Thu 17 Dec 2015 10:15

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

Macma · Post by **Macma** » Thu 17 Dec 2015 13:01

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

Best Regards,
Macma

MaximG · Post by **MaximG** » Fri 18 Dec 2015 10:45

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

Devart Forums

How INSERT, UPDATE and DELETE batch operations work

How INSERT, UPDATE and DELETE batch operations work

Re: How INSERT, UPDATE and DELETE batch operations work

Re: How INSERT, UPDATE and DELETE batch operations work

Re: How INSERT, UPDATE and DELETE batch operations work