vmulot Posted April 1, 2015 Share Posted April 1, 2015 Hi, I'm encountering a performance issue on my prestashop 1.6.0.9. I have 14 890 cart rules in the backoffice. In frontend, if i'm not logged in, it works well, but if i'm logged in i have huge perf issues. it is really slow. I enabled Prestashop's profiling tool: Load time: 19623 msYou'd better run your shop on a toaster Hook processing: 19364 ms / 221.08 Mb Hook Processing displayTop 212.39 Mb in 19005 ms SQL Queries: 29843 queries I noticed after some tests, that when i disable the blockcart module it works well again. The table stress of the profiling tools indicates me : 14892 cart_cart_rule 14890 orders 14889 order_cart_rule The object Model Instance Currency is instanciated 14890 also... any idea on how to debug that ? thanks Link to comment Share on other sites More sharing options...
hpar Posted April 1, 2015 Share Posted April 1, 2015 Hi, any idea on how to debug that ? You can run xhprof in order to know the costly modules / functions. Bye the way, I've written an article (in french) about how to use xhprof and xhgui with prestatshop Link to comment Share on other sites More sharing options...
vmulot Posted April 1, 2015 Author Share Posted April 1, 2015 Thanks for answering, i never used xhproof before, i'm gonna look at it. i'm pretty sure it's slow because of the 14 890 instance Link to comment Share on other sites More sharing options...
hpar Posted April 1, 2015 Share Posted April 1, 2015 According to your screenshot, there is also 30 000 queries to the database Link to comment Share on other sites More sharing options...
vmulot Posted April 1, 2015 Author Share Posted April 1, 2015 yep, and i think it's linked to the 14890 instances Link to comment Share on other sites More sharing options...
vmulot Posted April 1, 2015 Author Share Posted April 1, 2015 (edited) I manage to profile with xdebug and Qcachegrind (following some tuts) can ayone help me to understand that ? from what i see, the 2 most expansive things are CartRuleCore::getCustomerCartRules & OrderCore::getDiscountsCustomer but i can't understand why ... Can Prestashop handle something like 15 000 cart rules ? thanks Edited April 1, 2015 by vmulot (see edit history) Link to comment Share on other sites More sharing options...
vmulot Posted April 1, 2015 Author Share Posted April 1, 2015 In fact, i think Prestashop isn't designed to have too much cart rules. (it's quite logic), in fact in my case, cart rules where created in real shop (before the new website) and given to customer like a flyer. but several codes have the same rules... i think it would be nice that we can handle multiple different code for one rule. what do you think ? Link to comment Share on other sites More sharing options...
hpar Posted April 3, 2015 Share Posted April 3, 2015 I don't know cart rule system enough to give an advice. 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