Awadhesh Prajapati Posted November 2, 2017 Share Posted November 2, 2017 Hi All, As we have dedicated server with configuration....We are facing one big problem regarding the category limitation; we have one category where we uploaded more than 100k products. But now the problem arises, it gets too much of load time that it can't be able to open the category. What should we have to do, is there any limitation of product in one category? Or it depends on server/hosting provider whether they could manage the load or not? Is there any solution regarding the, we are keenly waiting for your response. Thanks Awadhesh Prajapati Link to comment Share on other sites More sharing options...
Simonas Invertus Posted November 2, 2017 Share Posted November 2, 2017 I guess the best solution might be to optimize SQL queries. Its hard to advice without detailed investigation. 1 Link to comment Share on other sites More sharing options...
Awadhesh Prajapati Posted November 3, 2017 Author Share Posted November 3, 2017 Hi Simonas Invertus, Thanks for your response i want just know how to optimize SQL queries i have no idea for this can you suggest any solution. Thanks Link to comment Share on other sites More sharing options...
musicmaster Posted November 4, 2017 Share Posted November 4, 2017 In defines.inc.php you can switch on profiling (_PS_DEBUG_PROFILING_). That will post under your page a list of all the mysql queries and how long they take. That should give you the insight you need to adapt the code. 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