Re: OK, I'm officially screwed if I can't get some suggestions

Hi, perhaps I am missing something, but I want to help, >PHP 4.0.4. IIS 4, Oracle 8 client, Oracle 7.3.4 backend, webserver in DMZ could it be that you need Oracle 7.3.4 client software, instead using Oracle8? Then you would use Ora_Logon (OCI7), instead OCILogon (OCI8) I experienced some months ago problems with client 8.1.6 and a 8.0.5 backend, so perhaps this is your problem too... why don't you try this approach (nothing to loose, unless all your PHP programming is made with OCI8 :-( ) Greetings, F.J.Ortiz 5/21/01 9:24:12 PM, "Asendorf, John" <JAsendorf@lcounty.com> wrote: >OK... > >PHP 4.0.4. IIS 4, Oracle 8 client, Oracle 7.3.4 backend, webserver in DMZ > >I'm having some speed problems with a data entry front end that is being >used in house. > >The queries sometimes (most times) take upwards of 13-17 seconds to run. >I've put a timer which starts at the beginning of the script and doesn't end >until the very end. It usually registers 2-3 seconds. I'm using sessions >via files. > >I've tried making the code as clean as possible, and the scripts themselves >seem to be running very fast. Would sessions be the most likely culprit for >my speed loss? It's (the slowness) threatening to kill the whole project... >We have a similar ASP/M$SQL server application (vendor product) which >blazes... and it's driving me nuts... > >Thanks in advance if you have some clues for me... > >John > >--------------------- >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 > > >-- >PHP Windows Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net >For additional commands, e-mail: php-windows-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net > > ___________________________________ Francisco Javier Ortiz Torre ComuNET,S.A. mailto:fjortiz@comunet.es ComuNET, S.A Gral. Concha 39,6º 48012 Bilbao España Tel: +34 944 700 101 Fax: +34 944 700 185 http://www.comunet.es ___________________________________