Hi,
Yesterday I was going through the Devart's website and I came to know that we can do batching using the "dotConnect for SQLite". So, I created an application (creating using Entity Framework Code First & dotConnect for SQLite) to test what kind of performance gain I get out of the batching.
So, I figured out that there was no performance gain I got using the batching. I just want that you guys could take a look at the code and let me know if, I am doing anything wrong.
You can download the sample application from https://onedrive.live.com/redir?resid=2 ... ile%2c.zip.
Thank you
Sincerely,
Pankaj Sachdeva
Batching test
Re: Batching test
Thank you for the test project.
SQLite is a local embedded database; that is why, the use of Batch Updates for SQLite does not always guarantee an increase in performance. In some cases, it might actually result in a performance decrease.
SQLite is a local embedded database; that is why, the use of Batch Updates for SQLite does not always guarantee an increase in performance. In some cases, it might actually result in a performance decrease.