Re: Apache::DBI and temporary tables

[Perrin Harkins]

On Tue, 2003-07-22 at 17:15, Michael A Nachbaur wrote:
 If I do a $dbh-disconnect, I know it will be ignored by Apache::DBI, but is 
 it smart enough to pass something back to the database server telling it that 
 it can purge temporary data?

No.  If you come up with a way to do that, you can add it as a cleanup
handler.

- Perrin

Re: Apache::DBI and temporary tables

[Frank Wiles]

On Tue, 22 Jul 2003 14:15:41 -0700
Michael A Nachbaur [EMAIL PROTECTED] wrote:

 Hello all,
 
 I know from a DBI perspective, when using PostgreSQL, if I create a
 temporary database table it will automatically go *poof* and be
 deleted when the database connection is closed (or when the
 transaction is finished...I can't remember which).  Anyway, what will
 happen if code that takes advantage of this is used in an Apache
 Registry script?
 
 If I do a $dbh-disconnect, I know it will be ignored by Apache::DBI,
 but is it smart enough to pass something back to the database server
 telling it that it can purge temporary data?

  While I'm not 100% sure, I would seriously doubt it since Apache::DBI
  doesn't call the corresponding DBD's disconnect method. 
 
  I would do  one of the following: 

  1) Explicitly clean up your temp table. 
  2) See if you can stop using Apache::DBI.

  I found on several sites that Apache::DBI didn't effect
  performance as much as I would have imagined with PostgreSQL and was
  fine to run without it. 

 -
   Frank Wiles [EMAIL PROTECTED]
   http://frank.wiles.org
 -