Performance improvement for sqlite3 database flush
|Reported by:||Owned by:||nobody|
|Component:||Database layer (models, ORM)||Version:||master|
|Has patch:||yes||Needs documentation:||no|
|Needs tests:||no||Patch needs improvement:||no|
The attached patch switches the synchronous pragma of the sqlite engine to 'off' during a database flush.
In my application I see a performance improvment with a factor 3 with this change.
Similar speed improvements are reported http://www.rkblog.rk.edu.pl/w/p/sqlite-performance-and-django/