I'm creating a page containing a form including a <select> field which <options> values are filled from a database query. I would like to cache the result of the query, in order to make the query only once, and therefore speed up the rendering. I really mean once, not once per session.
To the best of my knowledge (correct me if I'm wrong), you can't rely on instances variables to store persistent-accross-requests variables : the instance may or may be not reused, may or not be cached.
I though that storing the result of my query in a class variable would solve the problem, but it doesn't.
My code looks like this:
class MyPage(SitePage.SitePage):
def getData(self):
...
cur = self.con.cursor()
cur.execute("select foo, bar from mytable")
data = cur.fetchall()
options = ['<option value="%s">%s</option>' % x for x in data]
self.__class__.data = "<select>%s</select>" % options def writeHTML(self):
...
if hasattr(self.__class__, "data"):
# data already stored in a class variable
pass
else:
self.getData()
...
self.write(.... + self.__class__.data + ...)
So, my questions are :
1) why doesn't it work ? It's not a caching issue because my CacheServletClasses is set to 0 in my Application.config file.
2) what is the best way to make persistent variables accross requests and sessions ?
3) I did some mod_python programming and I used to deal with this issue by running a SOAP server alongside the HTTP server, which was holding all the persistent data. Is this an option with Webware or is there something more clever to do ?
many thanks,
Olivier
------------------------------------------------------- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php _______________________________________________ Webware-discuss mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-discuss
