Improving testing speed

Hi all:

Testing on the postgresql and mysql backends are particularly slow.
From a quick run, it looks like the setup routine that creates a database
and populates it takes a good amount of time.

I am considering trying to change postgresql at least to:

  1) create a templatedb in the setup method and record the existence of
     the database as a property of the test object.
  2) for each test that calls setup(), initialize
     the test database using: create rounduptest WITH TEMPLATE templatedb

Anybody know if this would work and if it would speed up the setup
routine?

Doesn't look like mysql or sqlite have an equivalent method but.....
 
Have a great week.

--
				-- rouilj
John Rouillard
===========================================================================
My employers don't acknowledge my existence much less my opinions.