0

Since I am going on shipping soon I wonder which generally will mostly boost the database performance ?

The bridge question is - which will boost mostly a database which having a lot of random block readings and deleting records ?

in a single drive performance :

  1. OCZ 240GB PCI Express RevoDrive 3 X2 SSD
  2. INTEL 240G SSD 530
  3. 15k SAS Raptor

and the most interesting - the performance with the same drives in RAID 10 ?

5

PCIe Flash will offer significantly better overall bandwidth than SSD or HDD therefore should provide better sequential IO, this may not play as big a part in random IO as you might think but you should still see a degree of improvement over regular SSD, both of which will be very significantly better at this than HDD.

Obviously cost/GB comes into play but that's your call.

Bear in mind that some PCIe Flash disks aren't bootable.

1
  • These are very useful hints, Chopper3. Thank You ! :) – Yordan Yanakiev Sep 5 '13 at 9:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.