Use transaction strategy to cleanup database in order to speed up running of the test suite

dovadi / emonWeb

Webapplication for energy visualisation for the emonBase platform

MIT License

5 stars 3 forks source link

Use transaction strategy to cleanup database in order to speed up running of the test suite #2

Open dovadi opened 12 years ago

dovadi commented 12 years ago

Ten specs will fail if we use a transaction strategy to cleanup the database, probably due to the use of 'native' sql in DataStoreSql

We now use truncation which works reasonable well with Postgresql 9.0.4, but is more than five times slower with Postgresql 9.1, see stackoverflow for further details