Stephan Beal wrote: > On Fri, Aug 12, 2011 at 1:51 PM, Sumit Gupta <[email protected]>wrote: > >> I was try to to Read a Binary file in to the Sqlite Database using .NET. >> All >> ....NET to do bulk upload. I use that Dataset method to upload about 70,000 >> records in to SQL server and it take 10-15 sec, but in Sqlite it is still >> taking minutes to record that data. >> > > The answer is the same as it was yesterday: wrap the inserts in a > transaction.
Besides putting all INSERT within a transaction, you can also try "PRAGMA synchronous=off" in case you don't mind having a corrupted database when OS crashes. Some operations can be much faster with synchronous=off (50 times faster or so according to the documentation): http://www.sqlite.org/pragma.html#pragma_synchronous -- Dominique _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
