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]
