Database activity makes test cases very slow

[Russell Keith-Magee]

The level of database activity required by the test system renders the testing process painfully slow. This is especially bad with django.test.TestCase - resets are very expensive operations, which can significantly slow down the testing process (to impractical speeds).

[Simon G. <dev@…>]

​discussion is here

[Nis Jørgensen <nis@…>]

Just out of curiosity: In my experience, this is a big problem with postgresql, and almost no problem with sqlite (which runs in-memory for tests). How slow are things in the other backends?

[simon]

This relates to #8138 which proposes running tests in transactions to speed up the database reset operation.

[Karen Tracey]

I'm going to call this fixed by r9756/#8138. There is perhaps more to do with speeding things up, but the specific item called out in the initial description here, that is the slowness of django.test.TestCase, was fixed in r9756.