there is not much really .... http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Caching-selects to see how to cache (it's not that different from the usual cache in web2py).
instead of db(db.table.id>0).select() you use db(db.table.id>0).select(cache=(cache.ram, 60)) if you can leave with the same data for 60 seconds without hitting the database. Moreover, if you use db(db.table.id>0).select(cache=(cache.ram, 60), cacheable=True) it'll be faster but your code can't use row.update_record() and row.delete_record(). If you want to use redis ... install it on the server,. than http://web2py.com/books/default/chapter/29/13/deployment-recipes#Caching-with-Redis . Instead of using cache.ram you use cache.redis. same API interface, handled transparently. Bonus point if you want to auto-fix the "thundering herd" problem (many users requesting a the same time something that isn't in cache): use with_lock=True and it'll be fetched one time only, while other wait in line the result calculated by the first client requesting the data. On Thursday, June 11, 2015 at 2:58:47 PM UTC+2, Fabiano Faver wrote: > > Niphlod, I have a small app the DB is getting big quickly and was asked to > do a cache layer..I just started started to learn about it and i'm already > lost. Could you point the direction to a newbie how to do it? Is it just > some code change in web2py? I saw there is this Redis but didn't read yet > how it works together with web2py and if it is this the way to do this > cache layer. > > > > Em quarta-feira, 24 de dezembro de 2014 16:10:15 UTC-2, Niphlod escreveu: >> >> so, what's the issue you're facing ? >> >> On Wednesday, December 24, 2014 12:29:24 PM UTC+1, harsha tanguturi wrote: >>> >>> I would like to cache the model data i.e., caching the selects and >>> update the cache whenever the data is updated. Putting simply a caching >>> layer has to present before the database layer and any changes to the >>> database should be reflected in cache too. >>> >> -- 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/d/optout.
