TheHolo.Net
Oct 11th, 2002, 04:21:03 PM
I'm not sure if anyone has noticed or said anything yet, but recently I decided to do a check on how many database queries our main index page was generating in an effort to try and keep things running as well as possible. In doing so I found well over 200 queries were being done in the later hours of the day just for the main index. A little further investigation revealed to me that the bulk of those queries were being caused by the "Who Was Online Today" display of the number of visitors to the forum today. That being the case I have revoved that number from the index and our query count for the main index is down to 28. The hack was performing a single query for each member that had visited in the nuber it was displaying.
The Who was Online Today page itself does not hit the database in the same way so I have left it in operation and left the link to it on the index.
So if someone asks why the number is no longer on the mainpage say it was in the intrest of optimizing our forums to run better that it was purposefully removed.
:)
The Who was Online Today page itself does not hit the database in the same way so I have left it in operation and left the link to it on the index.
So if someone asks why the number is no longer on the mainpage say it was in the intrest of optimizing our forums to run better that it was purposefully removed.
:)