My website is running Prestashop 1.4 and It's shared on a powerful VPS
But lately after it's receiving an increasing number of visits because of Adwords, it's suffering from slow performance and potentially 503 errors.
My hosting company reported a number of SQL queries which need to be well optimized to resolve the slow queries issue.
I need an SQL expert who can optimize these SQL Queries to a faster one, and also he should be an expert in Web hosting master to be able to study my current website performance and help to optimize its speed and performance.
Please bid with your expected causes and what will be your strategy to optimize the performance. I need a guarantee from your side that the latency and slow performance will be resolved.