SQLiteDataAdapter.UpdateBatchSize

[sun21170]

The UpdateBatchSize of SQLiteDataAdapter does not cause the INSERT or UPDATE of many records at time. Is this true or false? I was looking for something that will insert/update many records at a time.
By many records at a time, I mean many records are inserted or updated in same database trip.

[Pinturiccio]

The UpdateBatchSize property of the SQLiteDataAdapter class does not work. As we wrote you at the forum http://forums.devart.com/viewtopic.php?t=32863, SQLite API does not provide special functions for the bulk insert. The UpdateBatchSize property of the DbDataAdapter base class exists in all ADO.NET providers. However, in respect of the aforementioned peculiarities, it does not work in dotConnect for SQLite. We will investigate the possibility of implementing the correct work of this property and notify you about the results as soon as possible.

[sun21170]

Ok. Great. I appreciate your response and look forward to the bulk insert functionality for SQLite. Thanks.

[Pinturiccio]

We have investigated the issue. SQLite does not have additional functionality for bulk operations. We can unite several commands into one. This will improve performance for executing commands without parameters. However, SQLiteDataAdapter always uses commands with parameters. According to our calculations, concatenating commands, parameter parsing, changing their names, etc. would withdraw any performance gains and lead to many potential errors. That's why we decided not to implement the UpdateBatchSize property for the SQLiteDataAdapter class.