Friday, August 31, 2018

c++ - Writing records in SQLITE database taking huge time. How to improve efficiency of insert operation?

Insertion of approximately 110 million records in a table in database is taking huge time (>1hour) using C++ interface APIs.



Is there any way to bring this time down and improve efficiency of insert operation ?



I am grouping 1000 records in one transaction and then executing them.



sqlite3_exec(begin transaction);



sqlite3_exec(<1000> insertions);




sqlite3_exec(end transaction);



This is taking huge time.



How to improve efficiency of insertion?

No comments:

Post a Comment

plot explanation - Why did Peaches&#39; mom hang on the tree? - Movies &amp; TV

In the middle of the movie Ice Age: Continental Drift Peaches' mom asked Peaches to go to sleep. Then, she hung on the tree. This parti...