|FLUSH TABLES WITH READ LOCK| <flush.html>; http://dev.mysql.com/doc/refman/5.0/en/flush.html
On 17/08/2011 17:24, Shmuel Fomberg wrote: > hi all. > > at work we have a test suit that run against a database. so in the > beginning of the test it populate the database with a predefined data. > the problem is that this process is way too long, making the test suit > take a long time to run. > so I'm looking for options to cut this time. > > is there any ability to freeze a database? so all the changes will be > temporary and disappear in the end of the test, leaving the database in > a clean state for the next test? > maybe some kind of middleware? > maybe using transactions? (mysql supports transactions, right?) > can transaction hold a large amount of operations / data? (I don't want > to limit the test of what it can do to the data...) > > Shmuel. > _______________________________________________ > Perl mailing list > [email protected] > http://mail.perl.org.il/mailman/listinfo/perl
_______________________________________________ Perl mailing list [email protected] http://mail.perl.org.il/mailman/listinfo/perl
