On Feb 20, 2008 11:06 AM, Michał Bartyzel <[EMAIL PROTECTED]> wrote: > Hi, > > I use the newest version of SQLite - 3.5.6. > I have 9 MB file with insert statements to ".read" into the data base. > When I run it under Linux it takes up to 20 minutes, but when I run it > under WndowsXP it takes about 2 hours! > Does anybody know why?
Use transactions, that is, start with a "BEGIN" and finish with an "END". You will see that all your inserts will drop to just seconds instead of minutes (in Linux AND Windows). Regards, ~Nuno Lucas _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users