I've developed a web app for a client with a large MySQL database that is attacked with constant FULLTEXT lookups. We've tested it on various platforms, and using SSDs speeds up queries by a factor of at least three, sometimes going up to five.
OpenVZ I personally think is good for a host as you can oversell, but on a user point of view I wouldn't really recommend it. I think for a CPanel host now days using something like CloudLinux & CageFS is a must for security and performance which you can not use on OpenVZ.
█ Cyber Host Pro Ltd- over 10 years in the UK hosting industry.
█ Website Hosting | Reseller Hosting | Cloud VPS Servers | Dedicated Servers
★ WhiteLabel OnAPP Cloud VPS Reseller Program, Failover, 10Gbit SFP+ Dual SAN storage with Cpanel, Plesk & Windows server. www.cyberhostpro.com - UK Call Centre + 24x7 Online Chat
HostXNow - https://www.hostxnow.com | 8 Years In Business
Fast, Secure and Reliable [UK/FR/USA/CA]PURE SSD Web Hosting - Reseller Hosting - UK VPS Hosting
30 Day Money Back Guarantee - 24x7 Chat/Email/Helpdesk Support - 99.9% Uptime Guarantee