What's new
By:
Filters
Christian Forums

This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

Why does it take so long to post a message on this site?

My site was taking forever to load the index...like 30 seconds :o So I installed the footer hack (found here--http://phpbb-tweaks.com/down_db.h ... file-id-81) and it showed me that I had almost 300 SQL queries just to load the index. :o Most of those queries were blog related (we have blogs on there)....so I took another look at the blog code with the help of a php guru and found a loop that wasn't supposed to be there so it kept querying where it shouldn't have been....

All that to say that maybe you could install the footer hack so you could at least narrow down what is causing it...if it is a large number of SQL queries then the footer hack will tell you that.

Good luck,
 
It adds this to the bottom of your pages

Code: 
":: [ Load Time: 3.1 Seconds ] :: [ 26 Queries ] :: [ Query Log ] :: [ 8,640 Page(s) Viewed Today ] ::
:: [ Todays Queries: 196,147 ] :: [ Highest Load: 5,696,564 Queries On Jul. 20, 2005 ] ::
:: [ SQL Load: 69% Time: 3.5 ] :: [ PHP Load: 31% Time: 1.6 ] :: [ Debug: On ] :: [ GZIP: Disabled ] ::"

(Something similar to that at least. That's what mine just was for the index of my site. See where it says "26 queries"? When I first installed the footer hack it was over 280. See where it says "query log"? That's a link for the admin of the site where it will list each and every SQL query for that page...It was obvious when I looked at mine what was causing it to be slow because each query had "weblog" in it so I knew it was related to the blogs...aUsTiN and someone else from phpbb helped me troubleshoot from there and got my queries (and time to load the index) down considerably.

But, to answer the question, the footer hack just displays that code at the bottom of the page to help admins see how fast/slow their site is running and what is causing it to be slow if it is.
 
slowmodems3rf.gif



J/K :P
 
You must log in or register to reply here.
Back
Top