What is Query time and Solid State Drive in MySQLSolutionQue

What is Query time and Solid State Drive in MySQL.

Solution

Query time highly depends on the nature of the query. It depends in how many and what kind of joins are present in the query. It also depends on the number of tables being queried and the complexity of the where clause in the query.

A 7200 rpm hard disk typically provides 100 IOPS max, but a good solid state drive can provide 20000 IOPS or more. So, it can be 200 times faster approximately. So, if a query takes 200ms using hard disks (assuming there is no cache in the physical memory), then it would take 1ms using solid state drive.