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

We thought so too, but other scripts and ASP stuff runs fine... Regular http, firewal gets banged pretty hard all day. Client for this app are on the private side. --------------------- 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: Johan Lundqvist [mailto:johan@noatun.org] > Sent: Tuesday, May 22, 2001 5:31 AM > To: php-windows@lists.php.net > Subject: Re: [PHP-WIN] OK, I'm officially screwed if I can't get some > suggestions > > > Sounds to me like it might be the firewall messing things up. > Are the clients connecting with https? What's the workload on the > firewall? > > You said that the web server is in the DMZ. Where are the clients? On > the Private or Public side of the firewall? > > /Johan > > "Asendorf, John" wrote: > > > > 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.... > > > > --------------------- > > 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: Dan Cleveland [mailto:dc008274@mailhost.sju.edu] > > > Sent: Monday, May 21, 2001 3:37 PM > > > To: Asendorf, John > > > Subject: Re: [PHP-WIN] OK, I'm officially screwed if I > can't get some > > > suggestions > > > > > > > > > have you also tried cleaning up your sql table joins? > > > Depending on the > > > order of your where clause can increase or decrease speed. > > > > > > select * from table_1 T1, table_2 T2 where T1.id = 5 and > T2.id = 6 and > > > T1.t2_id = T2.id > > > > > > that select will run slower then > > > > > > select * from table_1 T1, table_2 T2 where T1.ts_id = T2.id > > > and T1.id = 5 > > > and T2.id = 6 > > > > > > the reason is because in the second one the table are joined > > > right away > > > and in the first a cartisean (sp) product is first made > of table_1 and > > > table_2 and then the rows are eleminated. So depeding on > your tables > > > sizes, the selects could be dragging the overall time down. > > > > > > Just a thought. > > > > > > Dan > > > > > > > +-------------------------------------------------------------------+ > > > | > | > > > | If Yoda so strong in force is, > | > > > | why words in proper order he cannot put? > | > > > | > | > > > > +-------------------------------------------------------------------+ > > > | > | > > > > +-------------------------------------------------------------------+ > > > | Daniel J. Cleveland > | > > > | e-mail: > dclevela@cnavsystems.com| > > > > +-------------------------------------------------------------------+ > > > > > > > > > > -- > > 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 > > -- > 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 >