I have built a website for a client using Prestashop. The website is just about done however the website loads very slow in some areas. Here are where the website seems to load very slow:
1. When searching for a product
2. When clicking a category that has many products.
The website does have over 100,000 products however we still need the website to run faster in the areas and above and if possible, just run faster and smoother throughout the website.
I have been told that the SQL queries need optimising or the tables need optimising to improve the performance of the website howver Im not expert in doing this.
If anybody knows alot about prestashop and are confident that they can help, please let me know! I only wish for people who feel they can do this job to bid as the client is wanting this fixed as soon as possible.
P.S - The website can be viewed at [url removed, login to view]