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 sec	34.0826 sec

Conclusion:
For the hardware and software we use, our SSD is better about 60% of the HDD. Please not that, our SSD is designed for personal use like laptops/desktops. Although that, it's also good for average servers. It's performance is better than HDD. You can see the difference with various tests.

The bad thing about this SSDs is cost/performance rate. Today the cost of this 16 GB SSD equals a 1 TB HDD. The cost is very expensive, if your priority is storage.

But if you want to speed up your operating system or database server, and your database is not bigger than 16 GB, you can buy a SSD for your workstation. Because our priority is performance rather than storage.

If you want to raise your performance more, you can connect your SSDs in raid. This will give you more performance.