Re: Howto optimize Distinct query over 1.3mil rows?

[John Stoffel]

Johnny> BIB_ID is VARCHAR, you should probably try
Johnny> WHERE BIB_ID='464' so MySQL treats the value as a string

Wow!  What a difference that makes!  Time to A) update my queries, or
B) fix the DB schema to NOT use varchar there.  

    mysql> select SQL_NO_CACHE distinct(Call_No) from Newspaper_Issues
    mysql> WHERE BIB_ID = 464;
    +----------+
    | Call_No  |
    +----------+
    | News     | 
    | NewsD CT | 
    +----------+
    2 rows in set (3.06 sec)

    mysql> select SQL_NO_CACHE distinct(Call_No) from Newspaper_Issues
    mysql> WHERE BIB_ID = '464';
    +----------+
    | Call_No  |
    +----------+
    | News     | 
    | NewsD CT | 
    +----------+
    2 rows in set (0.02 sec)

Thanks a ton for your help, I would have never figured this out, esp
since I was looking down all the wrong rat holes.  

Thanks,
John

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org