Hi, We are using sqlite to generate a schema with ~600 tables + 500 indexes + 50 views and some other triggers. Our module:
- Opens a transaction - Creates a table - Inserts some rows - Commits the transaction It seems this takes a lot of time to execute (doing it for all objects created), however in case we close and reopen the connection from time to time (at each 1000th transaction) things are working way faster. It looks like sqlite engine is doing something wrong when transactions are over used. Is there a known bug regarding this? Regards, Romy. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users