Have you benchmarked this and seen an actual improvement? With the one exception of SQLite, every database engine I'm aware of implicitly commits any open transactions before issuing a DDL statement such as a
Yes I'm using sqlite. The irony is that I'm now testing at home and there is no improvement any more (though I'm pretty sure to have same config as my work environment). I just debugged the connection but there is no commit before my createTables: so it seems that the backend is autocommitting, sounds weird. Nevertheless, if I dump a big schema (only the CREATE TABLE) and wrap it in a BEGIN; COMMIT;, then doing a "sqlite3 -init schema.sql data.db" is really faster than if I don't wrap it in a transaction. So it should be possible to have the speed bump. -- jt ------------------------------------------------------- All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642 _______________________________________________ sqlobject-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
