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 - [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
> 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:[EMAIL PROTECTED]]
> >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 - [EMAIL PROTECTED]
> >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:[EMAIL PROTECTED]]
> >> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
