Support Forum

Question about footer stats

CF Conrad_Farlow
Conrad_Farlow
Member

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?

6 Answers

New Answer

YS Yellow Swordfish
Yellow Swordfish
Member

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…

CF Conrad_Farlow
Conrad_Farlow
Member

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

SP SPQC
SPQC
Member

What’s the current update frequency?

 

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

MP Mr Papa
Mr Papa
Member

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…

SP SPQC
SPQC
Member

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!

MP Mr Papa
Mr Papa
Member

exactly why it is cached at one hour…

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