Ignored users seem to slow down the site... Using a new technique these slow downs from ignored users should be fixed!
SELECT * FROM messages_index LEFT JOIN ignored ON sender_id = ignored_link_id AND ignored_user_id = '1' WHERE receiver_id = '1' AND ignored_user_id IS NULL ORDER BY last_activity DESC, sender_id DESC
INSTEAD OF
SELECT * FROM messages_index WHERE receiver_id = '1' AND sender_id NOT IN (SELECT ignored_link_id FROM ignored WHERE ignored_user_id = '1') ORDER BY last_activity DESC, sender_id DESC
Anyways I'll work on it tomorrow...
Let me know if you find the site faster now that most (not all) of the ignore sql queries have been changed... There are a couple of problems with them, I'll fix them up a little more later on but for the most part should work.