* Noamn
> The query itself executes quite fast, but as it's one of the most
> frequently executed queries in the entire program, I thought it
> important to make it as fast as possible.

Have you considered changing the status column to an ENUM, and drop the
status table? (maybe not practical because of the displayorder column? Or
could this order be hardcoded in your application?)

--
Roger


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to