RE: THE SOLUTION

---------------------------------------------------------------------------- ----------------- Disclaimer: The information contained in this email is intended only for the use of the person(s) to whom it is addressed and may be confidential or contain legally privileged information. If you are not the intended recipient you are hereby notified that any perusal, use, distribution, copying or disclosure is strictly prohibited. If you have received this email in error please immediately advise us by return email at postmaster@normandy.com.au and delete the email document without making a copy. ---------------------------------------------------------------------------- ----------------- Out of interest John, have you tried PEAR::DB ? I gave it a while under Windows (as a CGI) and it seemed a tad slow compared to my own DB abs layer, or PHPLib. Maybe that it's problem too. Mark Nold markn@enspace.com <mailto:markn@enspace.com> Senior Consultant   Change is inevitable, except from vending machines. -----Original Message----- From: Asendorf, John [mailto:JAsendorf@lcounty.com] Sent: Thursday, May 24, 2001 3:46 AM To: Php-Windows (E-mail) Subject: THE SOLUTION First, thanks to everyone who chimed in with great suggestions on why my app was moving so slowly... In case you missed it, I was having problems with page return time while connecting to Oracle. Here's the solution. Every bit of code was just fine (well, fine ENOUGH I guess :) ). What I didn't know, and am about to put into the annotated manual as soon as this thank you is written, is that OCIPLogon only 'really' works when PHP is being hit as a module. What is deceptive is that you can use OCIPLogon in CGI mode, but it is unable to stay persistent (something that a little deductive reasoning should have exposed to me, but I'm not as smart as I'd like to think I am sometimes) if you run PHP as a module.... So, thanks for all the help. --------------------- John Asendorf - jasendorf@lcounty.com Web Applications Developer http://www.lcounty.com - NEW FEATURES ADDED DAILY! Licking County, Ohio, USA 740-349-3631 Aliquando et insanire iucundum est