DBI disconnect slow performance
From: Colleen (itss_at_erols.com)
Date: 03/30/05
- Previous message: Brandon Metcalf: "RE: embedding DB handle in object (was RE: adding key to DB objec t)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 29 Mar 2005 19:32:40 -0500 To: dbi-users@perl.org
I am having a problem with the DBI and/or DBD Oracle.
I have a Perl CGI application.
Using the Netscape web server, running on Solaris 9. Using perl 5.6.1,
DBI 1.30,
and DBD Oracle 1.12 for the CGI scripts.
The database is on a separate machine, running Oracle 9.2.0.4.0 on
Solaris 9.
The application is read only. We open a new connection with each script,
and close it at the end of the script. The scripts are all very typical -
maybe read some input from the screen, do a database select, format
the output, put to screen.
For some reason, the disconnect statements are taking a very long time
to execute. For example, a script that pulls 100 rows from the database,
formats them, and puts them to the screen takes 7 seconds to execute.
The disconnect statement itself is taking 6.5+ seconds of that time.
I scoured the web looking for any discussion of such a problem, but found
none. Am I unaware of some obvious bug with my software versions?
Any ideas?
Darrell Oresky
itss@erols.com
- Previous message: Brandon Metcalf: "RE: embedding DB handle in object (was RE: adding key to DB objec t)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
