Results 1 to 4 of 4
-
10-22-2016, 04:40 PM #1Aspiring Evangelist
- Join Date
- Jun 2009
- Location
- /
- Posts
- 370
SATA vs SSD a real life experiment with 42000+ rows
Hello People,
Yesterday I did an experiment with SATA and SSD hosting. I stored 42,742 rows in MySQL and I wrote same php/mysql code. I used Chrome https://chrome.google.com/webstore/d...pmkogoaohcdbig or Firefox https://addons.mozilla.org/en-US/fir...ded-statusbar/ or Firebug to see calculate actual loading time.
- SATA : https://360workspace.com/test.php (bdwebservices.com)
- SSD : http://104.152.168.33/~bdwebser/test.php (Crocweb.com)
- SSD : http://162.219.248.245/~bdwebser/test.php (Eleven2.com)
Seems SSD 10 to 15 Seconds faster than SATA.BD Web Services Since 2009
cPanel and Plesk | CloudLinux | Node.JS | SSD Server | Daily Remote Backup | North America and Europe | Money Back Guarantee
USA | Canada | Germany
-
10-22-2016, 05:43 PM #2Web Hosting Master
- Join Date
- Aug 2004
- Location
- Canada
- Posts
- 3,785
This isn't an accurate test as there are no guarantees you're in fact hitting the disk on each request. With the use of i/o caches the first read after a write could be read from memory or even a subsequent read of the data. You also need to factor in how the data ended up being stored on the drives. If I write the entire table out immediately and don't write any other data it could be a completely sequential read due to lack of fragmentation.
You really cannot compare SSD vs mechanical disks and use a testing methodology like this on a web host. There are all kinds of underlying technologies being utilized that could cause the disks to be irrelevant in the test.█ Tony B. - Chief Executive Officer
█ Hawk Host Inc. Proudly serving websites since 2004
█ Quality Shared and Cloud Hosting
█ PHP 5.2.x - PHP 8.1.X Support!
-
10-24-2016, 03:45 AM #3Web Hosting Guru
- Join Date
- Aug 2010
- Location
- Europe
- Posts
- 325
Have you ever tested the PCIE STORAGE`s (https://en.wikipedia.org/wiki/NVM_Express)? It would be so great to see the results between this device and SSD.
☁ Talk with me about your Cloud projects here directly: drift.me/tomaspeleckis
☁ Bare Metal Cloud & Dedicated Servers are ready! Pay with BTC, CC, PayPal
☁ Fully automated deployment, hourly billing, resource management, Elastic IPs, SSH keys etc.
-
10-24-2016, 01:38 PM #4
While I agree with @TonyB, I still like to see the results of these types of tests here. I think as long as we accept it for what it is, that's fine.
█ ProlimeHost - Dedicated Server Hosting & KVM SSD VPS
█ Three Datacenter Locations: Los Angeles, Denver & Singapore
█ SuperMicro Hardware | Multiple Bandwidth Providers | 24/7 On-site Engineers
Similar Threads
-
SATA vs SSD and ZFS
By SAHostKing in forum Hosting Security and TechnologyReplies: 1Last Post: 06-06-2016, 03:05 AM -
sata vs sas 15k vs ssd - vmware with two vps
By Clouseau in forum Dedicated ServerReplies: 8Last Post: 11-17-2014, 08:56 AM -
IO Speeds with 4x SATA vs 2x SATA + 2x SAS for MySQL
By Squidix in forum Hosting Security and TechnologyReplies: 3Last Post: 02-17-2011, 02:53 AM -
SAS vs SCSI vs SSD vs SATA?
By JABacchetta in forum Web HostingReplies: 6Last Post: 10-26-2009, 11:43 PM -
Drive Setup for VBulletin - 4 x SAS vs SSD vs Sata Raid-1
By Erich in forum Dedicated ServerReplies: 3Last Post: 04-05-2009, 11:32 PM