Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Question about footer stats
Avatar
Conrad_Farlow
Sheffield, UK
Member
Free Members
sp_UserOfflineSmall Offline
Feb 7, 2012 - 11:46 am

Where is the frequency of how often the footer stats are generated. I know that if a user logs out and I hit F5 the list updates.

What I would like is currently online is 'online in the last (for example) 15 mins...' and set the stats to be regenerated for that time interval.

Am I correct in thinking that they are only updated every hour? Where can I set the frequency of the stats updates?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 7, 2012 - 1:02 pm

You can't at the moment but we could consider exposing it.
The main thinking here is that the queries needed to update the stats are quite expensive so you don't really want them running that often but as I say we can talk it over here...

andy-signature.png
YELLOW
SWORDFISH
Avatar
Conrad_Farlow
Sheffield, UK
Member
Free Members
sp_UserOfflineSmall Offline
Feb 7, 2012 - 3:13 pm

I understand the rationale behind setting it at 1hr. However every 20 or 30 minutes should be an acceptable hit for our site. It would have to be an experiment to see at what level the performance hit was unacceptable.

So I say expose it and let us play. Maybe just have a few fixed settings 20,40 and 60 minutes perhaps?

Conrad

Avatar
SPQC
Member
Free Members
sp_UserOfflineSmall Offline
Feb 24, 2012 - 8:29 pm

What's the current update frequency?

 

nd for testing purpose, is there a way to force a refresh?

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Feb 24, 2012 - 9:02 pm

its 1 hour...  ticket open for future consideration to make it an option...

just put a call to:

sp_cron_generate_stats()

in your spFunctions.php and it will occur on every page load....  expensive query though...

Avatar
SPQC
Member
Free Members
sp_UserOfflineSmall Offline
Feb 24, 2012 - 9:07 pm

Mr Papa said

just put a call to:

sp_cron_generate_stats()

in your spFunctions.php and it will occur on every page load....  expensive query though...

Ouch!  that would slow down to crawl any popular forum with hundreds of users online at the same time.

I would prefer evey 5 minutes than on every page load.

 

Thanks for the answer and the tips!

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Feb 24, 2012 - 9:09 pm

exactly why it is cached at one hour...

for testing, which is what you asked for, shouldnt hurt...

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626