On 13 ?.?. 2010, at 17:43, Russell Keith-Magee wrote: > 2010/10/13 Jonathan Barratt <jonathan.barr...@knifeict.com>: >> On 13 ?.?. 2010, at 2:31, Jorge Vargas wrote: > >> A database migration might not be the sort of effort you were looking for, >> but I can only imagine that moving from SQLite to Postgres or MySQL would >> offer you the largest possible performance gains... > > Unlikely. When a test suite is run under SQLite, it runs entirely in > memory; PostgreSQL/MySQL test suites run with disk commits.''
Ahh, I see - not being an SQLite user myself but knowing the database image is a simple single file I had mistakenly assumed the opposite. Bad advise is worse than no advice, shame on me! > You can verify this by running Django's own test suite. I regularly see SQLite > test runs at about double the speed of the best I've seen under > PostgreSQL or MySQL. > > Testing is a situation that SQLite is extremely well optimized for -- > single user, no need for long term persistence. Thanks for the insight Russ, learn something new every day and all that... Yours gratefully, Jonathan -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.