Eydolan Posted May 18, 2021 Share Posted May 18, 2021 When trying to access a customer with a large order history (hundreds of orders) or when adding a few hundred items into the cart (its a B2B site) it becomes extremely slow and takes forever to execute. 92558 ms Total execution time 454 ms Symfony initialization 74.00 MB Peak memory usage When looking a the debug -> Performance it is the controller that is taking so long. I disabled all modules that I am not using, cache is on, I followed everything yet its slow, would it be the server? its a on dedicated server that is only running 3 prestashop installations. PrestaShop version: 1.7.7.3 MySQL version: 10.4.18-MariaDB-1:10.4.18+maria~stretch Server software version: Apache PHP version: 7.3.28-1+0~20210503.84+debian9~1.gbp6819da Memory limit: 512M Max execution time: 600 Upload Max File size: 128M anyone got any ideas? its basically making admin on the site and buying many products at once unworkable. Link to comment Share on other sites More sharing options...
ZHSoft Posted May 19, 2021 Share Posted May 19, 2021 Please try to increase your CPU and memory, maybe the effect will be much better. In addition, you need a professional DBA for database optimization and acceleration. Can you provide website information? Link to comment Share on other sites More sharing options...
Eydolan Posted May 19, 2021 Author Share Posted May 19, 2021 Thanks for your comments It got 512MB of memory that is allocated to this website. According to the logs presta memory usage has never gone over 100MB Some stats below on a page that takes really long to load Database Queries 1 Query time 0.63 ms Invalid entities 0 Second Level Cache disabled Render Time 292 ms Template Calls 21 Block Calls 23 Macro Calls 3 Cache Calls 29 Total time 6.61 ms Cache hits 22 / 27 (81.48%) Cache writes 2 Peak memory usage 66.0 MB PHP memory limit 512 MB Total time 135699 ms ! Initialization time 459 ms controller 135699 ms / 58 MB The database server is running on its own instant and and is not under load. There are only 8 databases on that server. Server is a Intel Xeon Quad Core 3.2GHz 16 GB ECC RAM Utilization stats are always very low. never under strain So basically controller is taking forever, not sure why or what it is doing or why? The server is a managed server and the hosting provider does have a DBA however they could not give me any solutions and said it must be the software. Link to comment Share on other sites More sharing options...
ZHSoft Posted May 19, 2021 Share Posted May 19, 2021 PrestaShop performance optimization acceleration server articles-cloud server optimization tutorial PrestaShop website performance acceleration optimization configuration Free to solve the problem of slow access, card problems, with operation tutorial Please try the above 2 optimized acceleration schemes. Link to comment Share on other sites More sharing options...
musicmaster Posted May 19, 2021 Share Posted May 19, 2021 In /config/defines.inc.php you can enable profiling. That will result in the downside of the page showing all the queries - including the time they take (you may need to scroll to the right for that). That will show you which queries take most time and will be a first step towards a solution. Link to comment Share on other sites More sharing options...
Eydolan Posted May 19, 2021 Author Share Posted May 19, 2021 many thanks let me try Link to comment Share on other sites More sharing options...
tuk66 Posted May 27, 2021 Share Posted May 27, 2021 It is a known long-standing problem. You can't have few hundred items in the cart! Link to comment Share on other sites More sharing options...
Eydolan Posted June 28, 2021 Author Share Posted June 28, 2021 is there anything that can be done? It starts getting slow from 40 items in the cart larges cart is close to 200 items and it becomes unusable slow Otherwise I will have to move e-commerce system. Can anyone recommend a system that can do large cart orders? Link to comment Share on other sites More sharing options...
Eydolan Posted June 28, 2021 Author Share Posted June 28, 2021 sorry forgot to mention, since the carts / orders are really large it also affects access of orders and customers on the backoffice. Clicking on one sometimes you need to work for many minutes. Its on a dedicated server Traffic to the website is extremly low. However when people order the order very large quantities. B2B site. if any one got any ideas what I can do as right now everyone is very unhappy. Link to comment Share on other sites More sharing options...
Diwad Posted March 24, 2022 Share Posted March 24, 2022 Hello @Eydolan did you find some solution? I also use presta for b2b and its extremely slow with big carts. Its ridiculous Link to comment Share on other sites More sharing options...
Eydolan Posted March 24, 2022 Author Share Posted March 24, 2022 38 minutes ago, Diwad said: Hello @Eydolan did you find some solution? I also use presta for b2b and its extremely slow with big carts. Its ridiculous no luck my side still very slow not going to usse presta on my next project it scales badly Link to comment Share on other sites More sharing options...
Nickz Posted March 24, 2022 Share Posted March 24, 2022 You have way too many products om page 1 Link to comment Share on other sites More sharing options...
Eydolan Posted March 25, 2022 Author Share Posted March 25, 2022 not sure what you mean by page 1 but its when there are to many products that get added to the cart. Link to comment Share on other sites More sharing options...
Diwad Posted March 25, 2022 Share Posted March 25, 2022 7 hours ago, Nickz said: You have way too many products om page 1 It's not about products on one page but in the cart... I can't tell B2B customer "hey, you have too many products in your cart" Link to comment Share on other sites More sharing options...
Diwad Posted March 25, 2022 Share Posted March 25, 2022 41 minutes ago, Eydolan said: not sure what you mean by page 1 but its when there are to many products that get added to the cart. Do you haveany specific prices groups? Link to comment Share on other sites More sharing options...
Nickz Posted March 25, 2022 Share Posted March 25, 2022 6 hours ago, Diwad said: It's not about products on one page but in the cart... how much memory you have allocated to PHP? Link to comment Share on other sites More sharing options...
Eydolan Posted March 25, 2022 Author Share Posted March 25, 2022 512mb Link to comment Share on other sites More sharing options...
Nickz Posted March 25, 2022 Share Posted March 25, 2022 Bring it to 720 and report. Or is that the RAM of your Server? 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