I Have a site where I sell car parts, using Prestashop 1.7.5.
There are many, many categories (at this moment, 15.000 entries), and it should have more than 100.000. I need 2 things for this:
Front-End: SPEED UP THE SITE, at this moment is taking about 25 seconds, it should take no more than 3 sec.
Back-End: Sometimes the page for modify/create a product haves some error 500. The objective is: to never have that issue, speed up the page.
a) The cars information needs to be always be in the categories information, any suggest of creating a new sql table is going to be ignored.
b) Im using 4GB of ram, 2CPU, 80 GB of SSD Storage. Any sugest of moving to another server is going to be ignored.
c) After making the implementation, I will active the CDN and a the module of “Cache Ultimate”.