[Zope-DB] Keeping db connection
Fri, 15 Nov 2002 20:54:41 +0100
Jakub Wisniowski writes:
> Hi. I have got a problem with using global temporary tables in my
> Sybase ASA with Zope. Global temporary tables are cleaned up after a
> client disconnects from database. In my application I get data from
> temporary table and present them for edition on the page. But after
> displaying that page my table is automatically cleaned up. Yes I want it
> to be cleaned but a little while later.
> So my question is - how to get and keep database
> connection for a desired amount of time? And of course how to
> release it later.
You may play with the ZODB cache parameters (Control_Panel -> Database Management --> Cache parameters).
It will not give you precise control over flushing, though.