120
Wow, I'm kind of surprised that this discussion hasn't generated more interest. Am I the only one out there with this challenge??
Anyway, I've turned on the MySQL debug mode and documented the query counts and page generation times for several pages on my site:
home page: 103 queries - 4.0959119796753 seconds to load.
pd-downloads root: 143 queries - 6.2500469684601 seconds to load.
pd-downloads category: 49 queries - 3.7887420654297 seconds to load.
wiki root: 66 queries - 4.8866550922394 seconds to load.
admin root: 4 queries - 1.0515160560608 seconds to load.
search: 43 queries - 7.092022895813 seconds to load.
It's early in the morning here and I'm the only person on the server. In other words, the numbers above are
best case.
So what's the best plan of attack here? Can server software (apache, mysql, etc.) optimization really make a significant difference in these load times? Would running this setup from a newer and faster box make enough of an impact on the turn around times? Or, is 103 queries to the same MySQL database always going to result in several seconds of waiting?
Thanks in advance guys! Sorry to be such on noob on this stuff!