[Xapian-discuss] Xapian on SSD vs SATA

[Henry]

Thanks for the reminder about flushing the system cache.

Using an SSD seems to only really (significantly) benefit phrase  
searches (~10x faster compared to a HD).

Machine has 3GB RAM.  SATA HD (7200rpm), Intel SSD X25-M G2.

Here's the results in seconds (avg of 4 runs):

14GB index               HD       SSD
----------               ------------
single keyword query:    2.0      1.2
2x word query:           6.2      4.8
phrase query:            33       3.9


4GB index                HD       SSD
----------               ------------
single keyword query:    1.4      1.1
2x word query:           1.8      1.5
phrase query:            3.5      0.3


As you can see, keyword queries are quicker, but lack the wow! factor.
Phrase queries *really* benefit - 10x faster is what one would expect  
from using an SSD.

So,... to conclude:  SSDs provide excellent gains for phrase queries -  
something 99.9999% of users won't use anyway :(

Henry