On 29 Jun 2011, at 2:27pm, profove wrote:

> There were about two hundred thousand of insert statements, but it
> executed too slow.

Before the first INSERT statement insert a command 'BEGIN;'.
After the last INSERT statement insert a command 'COMMIT;'.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to