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 - [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: Johan Lundqvist [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 22, 2001 5:31 AM
> To: [EMAIL PROTECTED]
> 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 - [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]
>
--
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]
