Huy Do wrote:
> Hi,
> 
> I was just wondering if anyone stores their db cursors (psycopg) in the
> session so the user can reuse the same cursor if necessary (i.e so the
> program does not have to re query the database). I am basically using
> this for a web page which for eg. List 30 rows at a time from a result
> set of 1000. This way, I don't need to requery when the user clicks
> next, prev etc. 
> 
> Can someone give me some comments on whether this will this work in
> Webware ?

This gave me lots of problems, though it seemed to work at first.  So, for
instance, when the AppServer tried to save it on disk, it would throw an
exception.  If you really want to store the results in the session, why not
pull them out of the cursor all at once into a list of dictionaries or whatever,
and store that in the session?

-- 
Randall Randall <[EMAIL PROTECTED]>
'Institute regime change everywhere...
 to "None of the above."' -- Alex Future Bokov



-------------------------------------------------------
This SF.net email is sponsored by: Scholarships for Techies!
Can't afford IT training? All 2003 ictp students receive scholarships.
Get hands-on training in Microsoft, Cisco, Sun, Linux/UNIX, and more.
www.ictp.com/training/sourceforge.asp
_______________________________________________
Webware-discuss mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/webware-discuss

Reply via email to