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