Stats update

[kinu99]

Hi !
How can i make my toplist stats ({$unq_in_0_monthly} / {$tot_out_0_monthly} ) update after 5 minute when someone vote ( not imediatly ) . Thx. and sorry for my english ..

 

[cajkan]

I think you need to use memcache - you need to ask you host.

 

[kinu99]

i was thinking that is some toplist script that make this ...

 

[cajkan]

Some websites have high traffic, and they cannot handle real time statistics so they use memcache to avoid mysql connections problems.

So using real time statistics - example ({$tot_out_0_monthly}) is better, but once your website gets populated you need to think about memcache.

 

[kinu99]

thx cajkan for your help

 

[Basti]

Yea, as far as i know you cannot even delay a given mysql query to perform xx minutes later.
What you may observe on other lists is cache, not memcache ( hard to configure ), but normal website content cache.

Serves a cached version of the site from 5 minutes ago, 5 mutes later grab a fresh copy.

Myself no experience with it, but i believe cloudflare lets you set up custom rules to only cache specific site content, such as rankings.php only
That way ranking is cached, but the rest of the site keeps instant update ( important for login for example )