Oracle Persistent Logon - Question about Logging off

From: Date: Thu, 02 Nov 2000 16:10:48 +0000
Subject: Oracle Persistent Logon - Question about Logging off
Groups: php.windows 
Request: Send a blank email to php-windows+get-3639@lists.php.net to get a copy of this message
I've greatly increased the search speed of a search utility I'm using in Oracle by using OCIPLogon... it's lightning now! BUT I'm not sure if the webserver is ever logging off of the database... (this will be a problem during our DLT backups every night...) how can I check? I have a line that runs an OCILogoff on the connection, but the next search screen doesn't take nearly as long to log on... Order of events: Added OCIPLogon to search form page (which is the same as the search results page) -----logon took a while Ran the search and got the results back almost immediately went back to the search form page -----logon took almost no time (yes I cleared the cache on my local machine) ---------- So I'm just worried about the webserver ALWAYS being connected to this database and am not sure how to check if the connection is ending after the end of the search... Thanks in advanve, John --------------------- Founder of The 'What Kind of Idiot Uses PHP with IIS with Oracle on NT?' Consortium Members: John Asendorf, Thomas Kryger, Florian Clever, Ron Woods John Asendorf - jasendorf@lcounty.com Web Applications Developer http://www.lcounty.com - NEW FEATURES ADDED DAILY! Licking County, Ohio, USA 740-349-3631

« previous php.windows (#3639) next »