Caching for database questions.
Posted
by
SeanD
on Stack Overflow
See other posts from Stack Overflow
or by SeanD
Published on 2011-01-15T23:31:08Z
Indexed on
2011/01/16
0:53 UTC
Read the original article
Hit count: 153
When we say caching like using memcahe or Redis, is this a 1:1 caching between the user and the cache or can we cache 1 item and use it for all user? Some items like a Friend list will be 1:1 a that is unique per user. But if i want to cache the auto complete list for city lookups which can be used by any user, will it just store 1 list in the cache used by all users at same time or doe it need to store 1 list per user?
Is it possible to cache the entire database, all the lookups, all the users, all their photos, etc using memache or redis?
So from the above example: a friend list will be cleared from the cache when the user logs off. But something like city auto complete will stay in the cache 24-7-365, am i correct?
© Stack Overflow or respective owner