For comparison, my test slave (dual core), with MySQL configured to use ample memory and the MyIsam folder on a tmpfs reliably runs tests in 5 minutes 30 seconds.<br><br>Damien Tournoud<br><br><div class="gmail_quote">On Sun, Dec 14, 2008 at 2:09 PM, Bart Jansens <span dir="ltr"><<a href="mailto:bart@motd.be">bart@motd.be</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Op zaterdag 13-12-2008 om 17:09 uur [tijdzone -0600], schreef David<br>
Timothy Strauss:<br>
<div class="Ih2E3d">> We have one of the MyISAM databases symlinked to tmpfs in RAM. It's<br>
> fast and somewhat unreliable, but I have no reason to believe that if<br>
> it provides test results that the results are compromised in accuracy.<br>
<br>
</div>I imagine it could make a lot more of a difference for SQLite,<br>
especially compared to the performance of an encrypted harddisk.<br>
<br>
<br>
FYI, A while back I ran some tests to check if I could improve the<br>
performance on my system. These were the results:<br>
<br>
- tweaking the Mysql config a little, improved performance by about 8%.<br>
And I'm not a mysql expert - others might be able to improve it even<br>
more.<br>
<br>
- placing the mysql db on tmpfs did improve performance slightly (1 or 2<br>
percent). But when running multiple tests in parallel, it actually<br>
degraded performance a little. I'm not quite sure why, but it was<br>
reproducible.<br>
<br>
- because modern CPUs have multiple cores, the highest performance boost<br>
was running the tests with higher concurrency. On my quad core, it would<br>
only take about 2 minutes to complete the tests. However, this proved to<br>
be somewhat unreliable, i kept getting database exceptions.<br>
<br>
<br>
<br>
Of course it all depends on the hardware, if you have a system with<br>
slower disk, mysql in tmpfs will be significantly faster. Check what the<br>
bottleneck is and start optimizing there.<br>
<br>
<br>
<br>
</blockquote></div><br>