Tanner Postert wrote:
so i am doing a query on an enum field:
when i do this query:
select *, id as vid, user_id as uid from video where (file_complete =
'true') order by undt desc limit 0,10;
the results are 0.16 or 0.17 seconds.
instead of saying file_complete = 'true. if i say file_complete != to the
other 5 possible enum values. the query returns in 0.00 sec.
there is an index on that field... shouldn't the = 'true' query be faster?
i just dont understand.
Are there more rows returned for 'true' than for the other values?
Have you tried using something other than a reserved word for 'true'?
What other values for file_complete could there be than true and false?
Why not define e.g. upload_status enum ('working', ...., 'complete').
(BTW you don't need those (parentheses) in your query.)
-J
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
