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

Reply via email to