Results 1 to 4 of 4
  1. #1
    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.



    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

  2. #2
    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!

  3. #3
    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.

  4. #4
    Join Date
    Mar 2009
    Location
    Here Today - Gone to Maui
    Posts
    9,966
    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

  1. SATA vs SSD and ZFS
    By SAHostKing in forum Hosting Security and Technology
    Replies: 1
    Last Post: 06-06-2016, 03:05 AM
  2. sata vs sas 15k vs ssd - vmware with two vps
    By Clouseau in forum Dedicated Server
    Replies: 8
    Last Post: 11-17-2014, 08:56 AM
  3. IO Speeds with 4x SATA vs 2x SATA + 2x SAS for MySQL
    By Squidix in forum Hosting Security and Technology
    Replies: 3
    Last Post: 02-17-2011, 02:53 AM
  4. SAS vs SCSI vs SSD vs SATA?
    By JABacchetta in forum Web Hosting
    Replies: 6
    Last Post: 10-26-2009, 11:43 PM
  5. Replies: 3
    Last Post: 04-05-2009, 11:32 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •