Re: How long is a model validation heavy testsuite supposed to run?

On 13 ต.ค. 2010, at 17:43, Russell Keith-Magee wrote:

> 2010/10/13 Jonathan Barratt <jonathan.barratt@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-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.