27
Dec
2009
We will share some MySQL results of our BigBoy SSD Slim. The hardware is the same as our previous post. This time the test is based on MySQL queries.
We did a simple sql select query like that:
SELECT * FROM `table` WHERE `field` LIKE '%keyword%';
Executed this query on the same table for keywords at different long. The table contains about 100.000 rows and it's size is about 500 MB.
| Test | SSD | HDD |
| Query 1 | 0.0261 sec | 0.0410 sec |
| Query 2 | 16.2090 sec | 28.2846 sec |
| Query 3 | 21.1690... |
(0)