I need a Magento and/or MySQL Database Expert to optimize the performance and loading speed of my website. The website it's going to have like 10,000 products and around 10,000 more categories/pages. Right now it has around 1,000 products and it's already loading really slow. I used to have a have a shared hosting account and moved to a VPS account. The performance and loading speed increased, but it's still very slow. It takes about 15 seconds to load each page. My test score on GTMetrix is an F (22%). I would like to make it at least a C or B and load at least under 5 seconds (preferably 3 or less). I also constantly get the following error message: "SQLSTATE[HY000]: General error: 2006 MySQL server has gone away" I contacted my hosting provider and this was their response has to why I keep getting the error message: "There are a lot of slow MySQL queries generated towards the database. The queries are being stacked up and they are overloading the MySQL service."
my suggestion. move away from magento. Magento is over-engineered to complicated and to resource intensive. My suggestion would be to use wordpress with woo commerce or a similar plugin. Trust me Magento = Rubbish.