Redis suggesstion for selecting data type

Posted by PHP Connect on Stack Overflow See other posts from Stack Overflow or by PHP Connect
Published on 2012-10-12T07:21:44Z Indexed on 2012/10/13 15:38 UTC
Read the original article Hit count: 95

Filed under:

redis

We have questions based where in home page we were showing 2 list

Questions by date modified
Question have bigger views and ans count. And in this both listing if question have same views or ans count then sorting is based on date.

Previously i am directly quiring to MySQL database and fetching the values so it's easy. But each page request hitting to MySQL it's bit expensive then start doing caching.

I started using Redis. Following is the cases when i use redis cache

Issues is On second listing i have to display questions by votes and not answered combine. How can i stored this type of data in redis to load faster with sorting based by 2 conditions votes with time and ans count with time?

Related posts about redis

Trouble using Upstart to launch Redis as redis user

as seen on Super User - Search for 'Super User'
I'm trying to launch redis-server as a user (called redis) via Upstart. My /etc/init/redis-server.conf looks like this: description "redis server" start on runlevel [23] stop on shutdown exec sudo -u redis /usr/local/bin/redis-server /var/lib/redis/redis.conf Looks good, right? I start redis-server… >>> More
Booting the server redis no errors

as seen on Server Fault - Search for 'Server Fault'
The redis but usually begins with the following errors: tyler @ tyler-vortex: ~ / pens $. / src / redis-server [3690] Dec 01 10:56:05 # Warning: the specified config file, using the default config. In order to Specify a config file use 'redis-server / path / to / redis.conf' [3690] Dec 01 10:56:05… >>> More
Redis 2.0.3 would not let go of deleted appendonly.aof file after BGREWRITEAOF

as seen on Server Fault - Search for 'Server Fault'
Ubuntu 10.04.2, Redis 2.0.3 (more details at the end of the question). My AOF file for Redis is getting too large, to the point where it soon would threaten to take whole free disk space on my small-HDD VPS box: $ df -h Filesystem Size Used Avail Use% Mounted on /dev/xvda … >>> More
Troubles installing/starting Redis via Resque

as seen on Server Fault - Search for 'Server Fault'
Trying to complete instructions for Resque/Redis installation here: https://github.com/defunkt/resque/blob/master/README.markdown Am stuck at where I'm trying to start up Redis via Resque at the following command: Craig:/usr/local/src/resque$ rake redis:start (in /usr/local/src/resque) Detach… >>> More
Resque Runtime Error at /workers: wrong number of arguments for 'exists' command

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm having a runtime errror when i'm looking at the "workers" tab on resque-web (localhost). Everything else works. Edit: when this error occurs, i also have some (3 or 4) unknown workers 'not working'. I think they are responsible for the error but i don't understand how they got here Can you help… >>> More

Developer IT