You can experiment with preloads, but it will be harder to maintain, and IMHO, itโs not worth the speed to improve (maximum 20%, I think, but it depends)
SQLite is known to be slower than mysql / pgsql, with the exception of very small, tiny DBs .
As already mentioned, you can put mysql (or other DB) data files on some RAMDisk (I use tmpfs for linux).
PS: now we have 1319 examples of Rspec, and it works for 230 seconds on C2D-3Ghz-4GRam, and I think this is normal. So yours is fine too.
source share