Wouter Overmeire <wover...@...> writes: [...]
> If I compare the speed of doing this for one file to an import statement in sqlite itself there is a big > difference, '.import' is much faster [...] Use transactions like this (will be much faster): BEGIN TRANSACTION; INSERT ....; INSERT ....; INSERT ....; INSERT ....; ... COMMIT; oliver _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users