The article https://www.drupal.org/node/466972 suggests to place sqlite databases in memory. I created a ramdisk and checked the simpletest performance. However, it turns out that the sqlite in-memory database is actually slower than a "normal" disk-based mysql database.
Why is that?

Comments

edaa’s picture

The full DB url is sqlite://localhost//dev/shm/sitetest.db, note: there are double '/' after localhost.

Result in very high performance!