On 11/29/2013 8:33 AM, Carlos Ferreira wrote:
Any of you know how to speed up the creation of empty tables in SQlite?
If I have to create more than 1000 empty tables to initialize my application
document it takes a while..
Make sure you run all CREATE TABLE statements within a single
transaction. My guess is you don't, and then most of the time is spent
in committing an implicit transaction after every statement.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
