Page: 1 | Rating: Unrated [0] |
Ignored Users
Good [+1]Toggle ReplyLink» Nuclear replied on Fri Jan 23, 2009 @ 4:11am |
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... | |
I'm feeling nuclear right now.. |
Good [+1]Toggle ReplyLink» neoform replied on Fri Jan 23, 2009 @ 10:03am |
Good [+1]Toggle ReplyLink» Nuclear replied on Fri Jan 23, 2009 @ 10:09am |
Works faster then the NOT IN for sure... Way way way way faster... I still didn't set it up, after lunch and stuff I will... | |
I'm feeling nuclear right now.. |
Good [+1]Toggle ReplyLink» Nuclear replied on Fri Jan 23, 2009 @ 5:36pm |
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. | |
I'm feeling nuclear right now.. |
Ignored Users
Page: 1 |
[ Top Of Page ] |
Post A Reply |
You must be logged in to post a reply.
[ Top Of Page ] |