Huge performance differences between i5 i7 SSD/non SSD...which makes more of a difference?

I have 2 pcs both running Windows 8.1 and each with 8b of ram.

The differences are one has a solid state drive the other one is 7200rpm and also an i7 vs i5

Running the same application one query takes 300 ms on the SSD and i7 machine while on the i5 and regular hard drive takes 1.8 seconds

Is the difference in performance related to processor or SSD?

This is a MySQL 5 database application doing multiple select statements using LIKE %%

Chris Muench

Posted 2015-08-02T03:57:14.427

Reputation: 569

database is primary a memory and I/O limited. – Ramhound – 2015-08-02T05:05:31.623

So based on that ssd drive might help? – Chris Muench – 2015-08-02T14:20:45.933

Answers

The SSD is providing most of the performance benefit, hands down.

As Ramhound mentioned, database performance is generally bound to memory and I/O performance. An SSD provides a quantum leap in performance benefit compared to a HDD in regards to random accesses (which is most likely your usage pattern).

i5 vs. i7 wouldn't provide a performance benefit of several times the original like you're seeing.

user5071535

Posted 2015-08-02T03:57:14.427

Reputation: 380