Oracle Persistent Logon - Question about Logging off
| From: | Asendorf, John | 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