bitclick Posted June 17, 2015 Share Posted June 17, 2015 Hello, I'm having a problem with slow queries using the homecategoryplus module (checked enabling profiling). In the profiling stats it shows the query with SQL_NO_CACHE taking 2-3s each, however in the module code it's not forced to use sql_no_cache. I read the ExecuteS() function manual, and if nothing is specified it should default to use_cache=1. So why all the queries this module is doing are looking for not cached data? Link to comment Share on other sites More sharing options...
Dh42 Posted June 17, 2015 Share Posted June 17, 2015 That is how debug profiling works, the queries are not cached for it. It will let you see the long queries that way. 1 Link to comment Share on other sites More sharing options...
bitclick Posted June 17, 2015 Author Share Posted June 17, 2015 So how can I check the query time under normal usage? I know that query is expensive, but once it's cached it shouldn't be taking that long and i don't need to change the results for 24h (when I update my products everyday). I want to know the time of that query after the first usage. Link to comment Share on other sites More sharing options...
bellini13 Posted June 18, 2015 Share Posted June 18, 2015 not the easiest solution, but locate the query that is being executed, and then run that query against your mysql database directly using phpmyadmin 1 Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
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