I do run a large board. I get about 8,500-9,000 posts a day. I did have the previous hit counter script running on the board, but with the duplicate hit problem I wrote another little application that does the hit counting for me. It's more accurate because it's only included in the footer.
The hit counting it intense, but it's worth the trouble and the load because it justifies banner advertising, and it's information that's required to do that.
My Linux AMD 3000 is currently running at a top static of a load average of 5-6 as peak times spiking to 12-15 at times. I'm currently in the process of aquiring a SCSI Ultra 320 drive and controller in hopes that it relieves some of the load on the box. If that doesn't work then I need to go with a dual processor box.
Quote:
Originally Posted by AN-net
running such a query on a large board can become database and server intensive which is not advised for webmasters who run their forums on shared hosting 
|