SLOW query - WHY???

2001-06-08 Thread Paul Wilkinson
Hi, I DESPERATELY need help! This motor does't seem to have a gas pedal.. It takes a full 4+ seconds to run! Only ~500 rows in table. I chopped a lot of group by ordering, etc off. SELECT d.DigIDsKey,d.Title,d.ValueEnglish,d.URL FROM DigIDs AS d WHERE d.DigIDsKey IN(22, 27, 84, 164, 272, 289,

Re: SLOW query - WHY???

2001-06-08 Thread Joshua J. Kugler
Did you try EXPLAIN query? That might give you some hints as to why it is taking so long. That might point you in the right direction. j- k- On Friday 08 June 2001 08:28, Paul Wilkinson wrote: Hi, I DESPERATELY need help! This motor does't seem to have a gas pedal.. It takes a