Optimization of the configurator module on Prestashop

Hello, Igor.
I carefully read your requirements and understood everything.
I think that to optimize the Prestashop configurator module and improve its performance, we primarily need to optimize the database query.
For example, avoid using `SELECT *` and select only the columns we need.
They can be released by using appropriate indexes for the columns used in the `WHERE`, `JOIN`, and `ORDER BY` clauses.
We also need to minimize the number of queries by aggregating them where possible and use prepared statements to separate data from queries, improving performance and security.
It is also important to implement caching.
This includes using a caching solution like Memcached or Redis to cache frequently used data and reduce database load, as well as enabling OPcache to cache compiled PHP bytecode and avoid recompilation on every request, and considering using a PHP caching library like Doctrine Cache or Symfony Cache to simplify caching implementation.
We also need to optimize the PHP code and enable built-in Prestashop caching options, such as page caching and combining CSS/JS files, using Prestashop's native database optimization tools to analyze and optimize the database schema.
… As a senior full stack developer with 10 years of experience in PHP and MySQL and an additional 5 years of experience in MySQL8, I am confident that I can perfectly complete your project and deliver it on time.
I would like to talk to you.
Thank you.

Show original

Translate

Hello, I have familiarized myself with the project brief.
About me:
✅ I have been creating websites for 3 years
✅ I promote websites
✅ Most expensive website: $4000

Show original

Translate

Hello! I will complete your task quickly and efficiently.

My portfolio: https://freelancehunt.com/ua/freelancer/romas6ka.html#portfolio
Write to me, I will start working today. I will be happy to collaborate with you!

I have been working with Prestashop for a long time.

Show original

Translate