Hello,
I have worked with SQL Express 2008 R2 earlier in an offline application which requires to insert data (around 2 - 3 million rows) in chunks as quickly as possible. The chunk mechanism is to not load the whole data in memory.
The overall time taken to load all the data was not as good as compared to Sqlite. And moreover, Sqlite does not require installation on the client machines.
I would like to know before experimenting if anything has improved in the aspect of batch inserts in SQL Express 2014. Is it worth spending time looking into this?
Thanks,
Srivathsal
Go to the complete details ...