iwizard Posted April 25, 2023 Share Posted April 25, 2023 (edited) Hi guys, We have a shop based on PrestaShop 1.6.1.24, with just over 115,000 products listed. This is hosted on a dedicated super fast server: AMD EPYC 7451 24-Core Processor Sandisk Corp WD Black 2018/PC SN720 NVMe SSD 256GB RAM 2666 MT/s CentOS Linux 7.9 10.6.12-MariaDB - all tables are InnoDB. FPM served by nginx/1.20.2 / php7 I've disabled most of the modules while testing, including Facebook Pixel, Google Analytics, MailChimp etc. Updated the menu module to a newer version, enabled all the performance settings and installed a Caching module which seems to work great. I've also disabled the Apache mod_security as well. While I'm aware this is a deprecated / not supported version of PrestaShop and while we're building the next iteration of the website on more modern technology, I'm trying to fix some issues with the super-slow times while updating a product and sometimes an order. Currently it takes over 30-40s to update a simple product and about 10s to update an order, eg adding a tracking number. Any other ideas on what can be done to make this faster? Thanks! Edited June 5, 2023 by iwizard (see edit history) Link to comment Share on other sites More sharing options...
ComGrafPL Posted April 25, 2023 Share Posted April 25, 2023 Hello, would be great to check the url. Also, caching modules can be tricky. If you need using such module and disabling other modules, integration is a bad sign. Link to comment Share on other sites More sharing options...
iwizard Posted April 25, 2023 Author Share Posted April 25, 2023 Hi, I've added some screenshots here, will PM you the URL. Link to comment Share on other sites More sharing options...
iwizard Posted April 25, 2023 Author Share Posted April 25, 2023 Some screenshots with the debug while loading the Catalogue / Product page in admin (first 3 images). vs while clicking Save on the Product, no edit done (next 4 images) Link to comment Share on other sites More sharing options...
iwizard Posted April 26, 2023 Author Share Posted April 26, 2023 Anyone else any suggestions? Worth converting the database tables from InnoDB to MyISAM? Link to comment Share on other sites More sharing options...
iwizard Posted May 8, 2023 Author Share Posted May 8, 2023 Any other suggestions guys? Still can't track down what's causing such a big slow down when updating a product and clicking Save. Link to comment Share on other sites More sharing options...
iwizard Posted May 8, 2023 Author Share Posted May 8, 2023 Any clue on why is doing these queries so many times on the same page? Link to comment Share on other sites More sharing options...
iwizard Posted June 1, 2023 Author Share Posted June 1, 2023 Not sure this help, but we've noticed if we associate the product to HOME category only it takes 1 second to save the product, if we associate to a CATEGORY / SUBCATEGORY / SUBCATEGORY it takes 30s-40s. Any ideas guys? Link to comment Share on other sites More sharing options...
Nickz Posted June 1, 2023 Share Posted June 1, 2023 On 4/25/2023 at 9:08 AM, iwizard said: AMD EPYC 7451 24-Core Processor Sandisk Corp WD Black 2018/PC SN720 NVMe SSD 256GB RAM 2666 MT/s up that RAM to 2 GB better that is very little. Also a huge Database will slow down a shop. Link to comment Share on other sites More sharing options...
iwizard Posted June 1, 2023 Author Share Posted June 1, 2023 6 minutes ago, Nickz said: up that RAM to 2 GB better that is very little. Also a huge Database will slow down a shop. Up to 2GB from 256GB? 🤔 Link to comment Share on other sites More sharing options...
Nickz Posted June 1, 2023 Share Posted June 1, 2023 6 minutes ago, iwizard said: Up to 2GB from 256GB? 🤔 sorry I though it'd be 256 mb, nope. How much do you have allocated in php.ini to php handler? Link to comment Share on other sites More sharing options...
Mediacom87 Posted June 1, 2023 Share Posted June 1, 2023 Hi, do you uninstall all unactivated module ? do you clean your database with very old datas ? Link to comment Share on other sites More sharing options...
iwizard Posted June 1, 2023 Author Share Posted June 1, 2023 6 minutes ago, Nickz said: sorry I though it'd be 256 mb, nope. How much do you have allocated in php.ini to php handler? See screenshots. Link to comment Share on other sites More sharing options...
iwizard Posted June 1, 2023 Author Share Posted June 1, 2023 (edited) 10 hours ago, Mediacom87 said: Hi, do you uninstall all unactivated module ? do you clean your database with very old datas ? Yes, only modules in use are enabled. What does that module clean? I cleaned shopping carts and connections manually. Edited June 2, 2023 by iwizard (see edit history) Link to comment Share on other sites More sharing options...
Mediacom87 Posted June 1, 2023 Share Posted June 1, 2023 Il y a 1 heure, iwizard a dit : What does that module clean? Ai cleaned shopping carts and connections manually. I've just reactivated the demo of this module; each action won't cause any deletion to avoid destroying the demo, but it will give you a clearer idea. Link to comment Share on other sites More sharing options...
iwizard Posted June 2, 2023 Author Share Posted June 2, 2023 10 hours ago, Mediacom87 said: I've just reactivated the demo of this module; each action won't cause any deletion to avoid destroying the demo, but it will give you a clearer idea. Yes, all that is done manually. Here is a snapshot of the largest tables in the database if it helps. Link to comment Share on other sites More sharing options...
Mediacom87 Posted June 2, 2023 Share Posted June 2, 2023 Il y a 5 heures, iwizard a dit : Yes, all that is done manually. Every day ? Link to comment Share on other sites More sharing options...
iwizard Posted June 2, 2023 Author Share Posted June 2, 2023 2 minutes ago, Mediacom87 said: Every day ? I get you're trying to sell your mod, not required, thanks. The clean up happens monthly. Link to comment Share on other sites More sharing options...
Mediacom87 Posted June 2, 2023 Share Posted June 2, 2023 il y a 13 minutes, iwizard a dit : I get you're trying to sell your mod, not required, thanks. The clean up happens monthly. In view of the volume of data processed, it might be preferable to set a shorter deadline. Of course, I want to sell my module, because it's great 😉 Joking aside, my comment wasn't about my module, but more about your practices. You're encountering something that's complex to identify, due to the very fact that to do so, you have to dive into dozens of tests in every direction to try and identify the blocking point concerning your site, not the neighbor's, but yours. So, I'm talking about one of the many elements to be analyzed and, above all, implemented on such a large volume of data: increasing server power is pointless if the problems are on elements that serve no purpose. Then, for each slow element, you need to study all the modules attached to the HOOKS used by these update functions, and study each SQL query present to see if a Database Index might be missing or necessary. Link to comment Share on other sites More sharing options...
iwizard Posted June 5, 2023 Author Share Posted June 5, 2023 SOLVED Fixed by disabling the cache. Saving a product now takes less than a second. Link to comment Share on other sites More sharing options...
Mediacom87 Posted June 5, 2023 Share Posted June 5, 2023 il y a 23 minutes, iwizard a dit : Fixed by disabling the cache. Saving a product now takes less than a second. I had forgotten about this option, never to be activated, as I mention in this article: https://www.mediacom87.fr/en/how-to-configure-the-performance-page-of-prestashop-17/ Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now