Hi all,
I have this use-case:
There is a set of rows being queried from the database.
videos=db(db.video.id>0).select()
Now I have three different views (in same controller) where I want to
access these rows (with additional filters), but I want to prevent
multiple db calls.
def index():
# use videos here with an additional filter
home_videos = [v for v in videos if v.folder == 'home']
def favorites():
fav_videos = [v for v in videos if v.folder == 'favorites']
These views essentially fetch subset of the same dataset and display
them.
Question:
-------------
Is there a way to "cache" the first db call "videos = ... " and be
able to access "videos" variable without hitting database again, as
long as this session exists?
I am not sure if and how I can use global variables here, and will
they reliably persist.
