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.... --------------------- 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| > +-------------------------------------------------------------------+ > >