Quote:
Originally Posted by hurik
hi,
very nice mod but i have a suggestion (i hope nobody has suggest this before, i was to lazy too read the whole thread!  ):
i would make an cron job which calculate the whole stats every hour and save it somewhere in the database and when an user look at the stats it only load the result and this would HIGHLY reduce the server loads.
my board has 800 k post, 20 k user and when 500 user are in the boards it take:
"Page generated in 187.23493004 seconds (0.05% PHP - 99.95% MySQL) with 41 queries" and i have an server with:
CPU: Dual-Core AMD Prozessor - Opteron? 1218
RAM: 4 GB
HD: RAID1 2 x 400 GB
ant thats only when i look at the stats. when i would make it open for all it would kill my server ...
hurik
i hope every body understand my bad english ...
|
Hurik, I'm sorry to hear that, you are the first owner of a bigger board that lets me know how this mod went.
This mod shows a lot of statistics, I wouldn't know how to cache them all.
I'm thinking of breaking the general statistics in pages, like Top Posters page, Thread Statistics page etc, I think that would help you to run this better. Let me know what you think and what pages with statistics you would like to see.
Oh and I understood you just fine