On 10 Jan 2011, at 1:10pm, Sunil Bhardwaj wrote: > We have large number of records in memory and we are using SQLite in-memory > using C++. > > How can we use Bulk Insert to speed up the record insertion process in SQLite > in one transaction.
CREATE TABLE ... BEGIN TRANSACTION INSERT ... INSERT ... INSERT ... END TRANSACTION CREATE INDEX ... If your table already exists and you're doing a lot of transactions it may be faster to drop the indexes before you start the transaction and remake them when it's finished. But this is not certain: try it both ways and see which is faster in your case. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
