I am looking for a magento webservice specialist who can help me with speeding up slow mysql queries in magento.
It takes very long to open product category pages and perform a search operation now.
The pages must open within a few seconds. It is crucial all information will remain the same, I am just looking for speed improvements without changing the content that is visible at the front-end.
Have a look at [url removed, login to view] to review the current situation.
Make sure all cron jobs for the webservice won’t get affected by the improvements.
You will work in a test environment server first, and after all is ready, you may transfer the files to the live version.