Speeding up sqlite tests

Bug #243139 reported by James Henstridge
2
Affects Status Importance Assigned to Milestone
Storm
Fix Released
Low
James Henstridge

Bug Description

When running the sqlite based tests, I noticed that the hard disk light flashes almost constantly. This seems to be caused by the fsync() calls when committing transactions.

Issuing the command "PRAGMA synchronous = OFF" on connection creation cuts about a third of the runtime from tests/store/sqlite.py. It might be worth adding an option to the SQLite Database implementation for this and using it within tests (it can cause data corruption though, so it should not be turned on by default).

More details on pragmas can be found here:

    http://www.sqlite.org/pragma.html

Related branches

Changed in storm:
importance: Undecided → Low
Revision history for this message
James Henstridge (jamesh) wrote :

Fixed in r251.

Changed in storm:
status: New → Fix Committed
Revision history for this message
James Henstridge (jamesh) wrote :

Fix released in 0.13.

Changed in storm:
assignee: nobody → jamesh
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.