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 - [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: Dan Cleveland [mailto:[EMAIL PROTECTED]]
> > 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: [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]
--
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]
