Re: tactics to improve ORDER BY and LIMIT (different question)

[Aftab Khan]

Also provide
What mysql version you are uing?
mysql> select version();
Also provide us
mysql> show global variabels like 'sort%'

if possible switch to 5.1 and use "List Partitioning Method" i.e. STATUS

CREATE TABLE posts
(....
)
PARTITION BY LIST (STATUS)
(PARTITION statuses VALUES ('Approved', ...);