On Thu, 2006-06-01 at 17:19 +0200, jt wrote: > I have to often create lots of tables (I know this is a silly use > case). To speed up this process I pass a transaction to the > createTable() method:
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 table create/alter/drop, so I wouldn't expect a transaction to boost the speed of creating tables. -- Matt Good <[EMAIL PROTECTED]> ------------------------------------------------------- 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
