Testing SQLite on Linux
This may be obvious, but if you place the database file on a tmpfs, it runs much faster. You can do this by specifying e.g. /dev/shm/drupal as the database name when you install. Pointless for a real site, of course, but useful for a once-off local install to run the simpletests. On my laptop (which admittedly runs dm-crypt, perhaps putting the HD at an unfair disadvantage) the difference is on the scale of under 17 minutes versus over two hours for running the full test suite. Just a heads up in case anyone else didn't realize this. -john
This is what we are doing on http://testing.drupal.org. Kieran On Fri, Dec 12, 2008 at 6:45 PM, John Morahan <john.morahan@gmail.com>wrote:
This may be obvious, but if you place the database file on a tmpfs, it runs much faster. You can do this by specifying e.g. /dev/shm/drupal as the database name when you install. Pointless for a real site, of course, but useful for a once-off local install to run the simpletests.
On my laptop (which admittedly runs dm-crypt, perhaps putting the HD at an unfair disadvantage) the difference is on the scale of under 17 minutes versus over two hours for running the full test suite.
Just a heads up in case anyone else didn't realize this.
-john
Wait, we're running SQLite on TDO? Dmitri On Dec 12, 2008, at 8:01 PM, Kieran Lal wrote:
This is what we are doing on http://testing.drupal.org.
Kieran
On Fri, Dec 12, 2008 at 6:45 PM, John Morahan <john.morahan@gmail.com> wrote: This may be obvious, but if you place the database file on a tmpfs, it runs much faster. You can do this by specifying e.g. /dev/shm/ drupal as the database name when you install. Pointless for a real site, of course, but useful for a once-off local install to run the simpletests.
On my laptop (which admittedly runs dm-crypt, perhaps putting the HD at an unfair disadvantage) the difference is on the scale of under 17 minutes versus over two hours for running the full test suite.
Just a heads up in case anyone else didn't realize this.
-john
Sorry, we mounted the MySQL server database files on a tmpfs in RAM. David Strauss can provide details. Kieran On Fri, Dec 12, 2008 at 8:28 PM, Dmitri Gaskin <dmitrig01@gmail.com> wrote:
Wait, we're running SQLite on TDO? Dmitri
On Dec 12, 2008, at 8:01 PM, Kieran Lal wrote:
This is what we are doing on http://testing.drupal.org.
Kieran
On Fri, Dec 12, 2008 at 6:45 PM, John Morahan <john.morahan@gmail.com>wrote:
This may be obvious, but if you place the database file on a tmpfs, it runs much faster. You can do this by specifying e.g. /dev/shm/drupal as the database name when you install. Pointless for a real site, of course, but useful for a once-off local install to run the simpletests.
On my laptop (which admittedly runs dm-crypt, perhaps putting the HD at an unfair disadvantage) the difference is on the scale of under 17 minutes versus over two hours for running the full test suite.
Just a heads up in case anyone else didn't realize this.
-john
participants (3)
-
Dmitri Gaskin -
John Morahan -
Kieran Lal