close Warning: Can't synchronize with repository "(default)" (Unsupported version control system "svn": Can't find an appropriate component, maybe the corresponding plugin was not enabled? ). Look in the Trac log for more information.

Opened 15 years ago

Last modified 14 years ago

#54 accepted enhancement

Use APC to cache the featured user

Reported by: ajanata Owned by: ajanata
Priority: major Milestone: time_t overflow
Component: SocialGamer Website Keywords:
Cc:

Description

Again, cache the featured user with apc_add. This can be stored indefinitely and manually reset when we edit the featured user.

Change History (6)

comment:1 Changed 15 years ago by ajanata

However if the featured user isn't streaming then we have to resort to picking a random live user, which does still need to hit the database (or at least look at the cache of the online users).

comment:2 Changed 14 years ago by ajanata

  • Milestone changed from January 2010 to July 2010

comment:3 Changed 14 years ago by ajanata

  • Milestone changed from July 2010 to August 2010

comment:4 Changed 14 years ago by ajanata

  • Milestone changed from August 2010 to Rock Band 3 Release

comment:5 Changed 14 years ago by ajanata

  • Status changed from new to accepted

This is more correctly implemented by caching the homepage list of streams directly, as the featured user is pulled up directly in that query. We should just cache that list for 10-30 seconds or so, similar to how the /streams/ page does it.

comment:6 Changed 14 years ago by ajanata

  • Milestone changed from Rock Band 3 Release to time_t overflow

Eh, putting this off. The homepage should be mostly dynamic in this regard. I'll revisit this sooner if there is enough load on the server that it might matter.

Note: See TracTickets for help on using tickets.