RE: [PHP-WIN] OK, I'm officially screwed if I can't get some sugg estions

LATEST UPDATE: It looks like I've found my culprit... I have an include (dl_app.inc) which contains the following lines: These lines are eating up 12-14 second of the 14-16 second run time... (EVEN WITH THE connection check commented out i.e. the check didn't seem to make any difference) I get the same problem if I put the code directly into the script itself I never have an OCILogoff in any of the scripts that this runs through... Is the OCI P Logon valid when using an 8.1.6 client and a 7.3.4 database? ------- /* Simple Oracle Connection */ //establish persistent logon if ( $debug ) { echo "DEBUG: Connecting to Dog License dB<br>"; } //connection info login, password, SID $connection = OCIPLogon( "user" , "password" , "sid" ); //not the real ones so don't bother /* check the connection if ( !$connection ){ if ( $debug ) { echo "DEBUG: Bad connection"; } echo OCIError( $connection ).":".OCIError( $connection )."<br>"; exit; } */ -------- --------------------- 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 > -----Original Message----- > From: Svensson, B.A.T. [mailto:B.A.T.Svensson@lumc.nl] > Sent: Tuesday, May 22, 2001 8:56 AM > To: Asendorf, John; Php-Windows (E-mail) > Subject: RE: [PHP-WIN] OK, I'm officially screwed if I can't get some > sugg estions > > > So we can exclude the hardware then. :) Assuming the queries runs > for about the same time in the RDBMS', then I would like to agree > with Johan Lundqvits: It seams to be something wrong on (ISO) > Transport, Network, Session level, etc. > > Maybe you should review which transport protocols are used within > both configurations. And then analyze which way the packets is > communicated over the network, and determine what kind of > bridges, etc. etc the traffic has to pass, and check what kind > of eventually services that might be able to filter you applications. > > > >-----Original Message----- > >From: Asendorf, John [mailto:JAsendorf@lcounty.com] > >Sent: Tuesday, May 22, 2001 2:44 PM > >To: Svensson, B.A.T. ; Php-Windows (E-mail) > >Subject: RE: [PHP-WIN] OK, I'm officially screwed if I can't get some > >sugg estions > > > > > >No noticeable delays coming out of anything else I'm afraid. > >Everything > >else seems to blaze... > > > >--------------------- > >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 > > > > > >> -----Original Message----- > >> From: Svensson, B.A.T. [mailto:B.A.T.Svensson@lumc.nl] > >> Sent: Tuesday, May 22, 2001 6:54 AM > >> To: Asendorf, John; Php-Windows (E-mail) > >> Subject: RE: [PHP-WIN] OK, I'm officially screwed if I > can't get some > >> sugg estions > >> > >> > >> >I don't think that it's an SQL issue. Searches on the > >> customer "Smith" run > >> >through and back (including formating the data) in about 3.5 > >> seconds (per > >> >the timer in the script) but take about 15 seconds to see a > >> response on the > >> >client. The whole building is base-T and fiber.... > >> > >> Sound like the lag-monster are eating networks packages again... > >> > >> Are other (applications) connection's suffering a similar kind of > >> lag (or any notable delays?) > >> > >> An extreme long shot might be hardware problem. :) We once at > >> my former > >> company had severe networks delays. Nobody really knew > what it was. A > >> guy (which was an idiot anyway:) suggested that this was > because lots > >> of people were downloading (to much and big) stuff. I had a regular > >> ping on the gateway, but couldnt notice any deviation > >because of this. > >> After a couple of weeks, we had a electrician there, and he found > >> oxide on the plugs for the network cables in the main switch... > >> > >> After removing the faulty plugs, everything went oki again... > >> > > > > -- > 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 >