Optimization of the configurator module on Prestashop
Hello!
I have several stores on Prestashop and I am looking for an experienced programmer for long-term cooperation. Currently, the priority is to optimize the existing configurator module, which has significantly slowed down after the update to MySQL 8, mainly due to the lack of cache in the new version. I am focused on improving the performance of this solution. Key technologies are PHP and SQL.
Additionally, in the future, I plan to address other topics related to Prestashop, such as modifications in JavaScript, Smarty, and other modules.
-
15 days1057 USD
4097 5 1 15 days1057 USDHello, 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.
-
3 days1057 USD
374 4 0 1 3 days1057 USDHello, 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
-
15 days793 USD
12912 67 0 15 days793 USDHello! 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.
Current freelance projects in the category Web Programming
It is required to deploy a ready-made HTML site on WordPress (ACF)There is a fully ready one-page business card website - it was created by Cloud Code The contractor receives a ready ZIP archive (HTML/CSS/JS). It is necessary to make a quality adaptation for WordPress without using Elementor and other heavy builders.What needs to be done1.… Web Programming, Website Development ∙ 18 minutes back ∙ 38 proposals |
Integration of Viber into 1C 8.3
223 USD
Project Meta Implement Viber integration without using third-party CRM systems. All work with messages should be done directly in our internal CRM based on BAS / 1C 8.3.Current System BAS / 1C 8.3 Custom configuration "Customer Service" Database of over 40,000… Databases & SQL, Web Programming ∙ 1 hour 22 minutes back ∙ 11 proposals |
Setting up Facebook Pixel on an e-commerce site
100 USD
FB Pixel setup is required for the e-commerce store; in addition to the standard checkout, there are several types of contact forms that also need to be tracked. Please specify your vision on what events and data need to be collected on this site and how to set up their… Web Programming, Social Media Advertising ∙ 2 hours 33 minutes back ∙ 37 proposals |
Changes need to be made to the home cleaning booking form on the website.The form already exists and works. Only the logic for the home cleaning service needs to be changed. Other forms and services should not be touched. 1. The first step of the formCurrently, the client selects:- the area of the dwelling (m²);- type of cleaning:- One-time; -… Web Programming ∙ 4 hours 3 minutes back ∙ 54 proposals |
Automation of sending KP messages on LinkedIn, WhatsApp, Reddit
223 USD
Automation is needed for sending messages with a link to the KP on LinkedIn, WhatsApp, Reddit. Please describe how this will be implemented, the timeline, and the cost. AI & Machine Learning, Web Programming ∙ 15 hours 56 minutes back ∙ 31 proposals |