Search the Community
Showing results for tags 'sql queries'.
-
Hi , I work on a site based on Prestashop jmband.dk. It has this problem that its not stable . Sometimes its fast and sometimes slow. We tried many servers and now we are on VPS server. We have 11 multi shops configured in our Back office. We tried to cjeck our website speed on pingdom.com and then it says that we have around 31 css files and also large number of javascript files that get loaded when the site is loaded. But this is the structure of Prestashop and we cant do anything. Now I tried checking the site on another tool called new relic and it shows that some database queries take a long time. It shows that ps_meta sql query is called more than 60 times and that takes a long time. My question is ps_meta has the pages of the website. So does it need to be called so many times or what else can I check to come out of this issue. Thanks, Manila
-
I have searched the documentation and the forums, and I'm rather shocked to discover that presta shop doesn't appear to have even simple sales reports. How do people who use prestashop keep track of their sales? Am I just missing it? Is it just assumed everyone knows how to write SQL queries to get a list of everything that was sold and to whom? CJ
- 10 replies
-
HI Guys.. been banging my head against the wall. I'm trying to run a query to find: how many new customers per week how many return customers order per week please help totally stuck aaahhhhh!!!