I would like to cache every row of my database table, in order to be able to do updates based in the key query.
This would be my table: channel : string (Unique) id_playing: integer tstart: integer duration: integer order: integer The querys are like this: db(db.mytable.channel==channel).select().first(), based on the channel string. I would be interested in clearing/updating the rows cached, using "channel" like the key (i.e. erase the cache with the key channel=rock). Could I use cache for this? I have never used any type of cache, so I really don't have any idea about this. I have read that this is not the usual scenary (I understand the usual would be erasing all the cache, or storing just a few values)... Someone could give me some hints about this or any other approach that I could use? I guess my application is not gonna be the next viral app, but just in case... how many rows could I cache... which order or gap? Betwen 100-1k, 1k-10k... 100k...1M? I know it's a vague question and can depends a lot of server and so on... but I don't have any clue, so some points would be apreciated. Another question would be about using ram or disk... I gues ram is not very advisable for this purpose... so the question would be, caching in disk is only limited by the space of your server? Thanks and sorry if it seems too foolish question -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
