By Sean on Wednesday, 26 March 2014
Posted in General Issues
Replies 5
Likes 0
Views 875
Votes 0
While having system profiler enabled, I've noticed a huge amount of queries to the database(mainly with EasySocial), in excess of well over 300?! Unless I'm reading this wrong, is this an issue to be concerned of while on a shared hosting account? If so, what can I do to lower that?

See the attached image
Hello Sean,

It's perfectly fine actually. Large number of queries does not mean it slows down your site. People need to start thinking of the opposite because what slows down a site is when your SQL query is bogged with lots of table joining (to reduce sql queries) but it always pose a threat of generating a slow query. In your stream, you have a wide variety of data which they all pull the sources from multiple locations of tables. It's perfectly fine in this case
·
Wednesday, 26 March 2014 01:05
·
0 Likes
·
0 Votes
·
0 Comments
·
Ok. Thanks for the quick response! That's a bit of weight off my shoulders.
·
Wednesday, 26 March 2014 01:49
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Sean,

Which tool do you use to see the database queries?
·
Wednesday, 26 March 2014 04:19
·
0 Likes
·
0 Votes
·
0 Comments
·
The System Profiler tool within EasySocial
·
Wednesday, 26 March 2014 09:28
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for updating Sean
·
Wednesday, 26 March 2014 11:28
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post