[Zope-DB] Keeping db connection

Dieter Maurer dieter@handshake.de
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.