Op zaterdag 13-12-2008 om 17:09 uur [tijdzone -0600], schreef David Timothy Strauss:
We have one of the MyISAM databases symlinked to tmpfs in RAM. It's fast and somewhat unreliable, but I have no reason to believe that if it provides test results that the results are compromised in accuracy.
I imagine it could make a lot more of a difference for SQLite, especially compared to the performance of an encrypted harddisk. FYI, A while back I ran some tests to check if I could improve the performance on my system. These were the results: - tweaking the Mysql config a little, improved performance by about 8%. And I'm not a mysql expert - others might be able to improve it even more. - placing the mysql db on tmpfs did improve performance slightly (1 or 2 percent). But when running multiple tests in parallel, it actually degraded performance a little. I'm not quite sure why, but it was reproducible. - because modern CPUs have multiple cores, the highest performance boost was running the tests with higher concurrency. On my quad core, it would only take about 2 minutes to complete the tests. However, this proved to be somewhat unreliable, i kept getting database exceptions. Of course it all depends on the hardware, if you have a system with slower disk, mysql in tmpfs will be significantly faster. Check what the bottleneck is and start optimizing there.