martin_88 Posted November 27, 2019 Share Posted November 27, 2019 Hello, My website became really, really slow. Impossible to connect in the backend, it takes minutes to log in, open a page, configuration, module or whatever. I tried to look up on Google Page speed and other, seem I have issue with "Reduce server response times (TTFB)". I try to debug, look at the log, nothing's really there. I set up the profiling tool but I don't get what to look at : Using PS 1.7.6 Using OVH mutu server. Any idea where I can look up ? Link to comment Share on other sites More sharing options...
NemoPS Posted November 29, 2019 Share Posted November 29, 2019 That's a lot of rows, a vanilla 1.7.6 has about 360. Can you check the table and see if anything looks odd? Like duplicate entries Link to comment Share on other sites More sharing options...
NemoPS Posted November 29, 2019 Share Posted November 29, 2019 I mean ps_configuration and its _lang counterpart Link to comment Share on other sites More sharing options...
martin_88 Posted November 29, 2019 Author Share Posted November 29, 2019 How do you see that I have lots of rows ? I have 2170 entry in PS_Configuration and less that 500 in PS_congiration_lang. How to clean this up ? Link to comment Share on other sites More sharing options...
NemoPS Posted November 30, 2019 Share Posted November 30, 2019 In your query, it says it's over 6 thousands it depends, how do the entries look? Over 2k is still a lot even with several custom modules. Do you have a multistore environment? That would explain it. Link to comment Share on other sites More sharing options...
martin_88 Posted November 30, 2019 Author Share Posted November 30, 2019 Hum, I don't have multi-store. I'll look at it and try to identify the duplicates. any advice on how to proceed ? Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted November 30, 2019 Share Posted November 30, 2019 it would be helpful to have front office url, you can delete later Link to comment Share on other sites More sharing options...
NemoPS Posted December 2, 2019 Share Posted December 2, 2019 order them by name in the table, you'll immediately see if there are duplicates. Just check a few pages to be sure Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted December 2, 2019 Share Posted December 2, 2019 you can simply empty the three _connections tables without issue.... 1 Link to comment Share on other sites More sharing options...
borkerdk Posted February 13, 2020 Share Posted February 13, 2020 On 12/2/2019 at 6:39 PM, El Patron said: you can simply empty the three _connections tables without issue.... Trying to solve a issue with a slow frontpage, for a customer. Truncating the connections tables, solved the issue. Perfect! thank you. 1 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