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 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, 533)
>
> I have indexed DigIDsKey
> Setup: MySQL 3.23.33
> Paul
--
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
