| Page: 1 | Rating: Unrated [0] |
Ignored Users
| Good [+1]Toggle ReplyLink» Nuclear replied on Fri Jan 23, 2009 @ 4:11am |
 Coolness: 2603990 | 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 |
 Coolness: 339670 | Eesh. Left join.. yuck. |
| I'm feeling pompous right now.. | |
| Good [+1]Toggle ReplyLink» Nuclear replied on Fri Jan 23, 2009 @ 10:09am |
| Coolness: 2603990 | 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 |
| Coolness: 2603990 | 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 |
[ Cumbre de Página ] |
Post A Reply |
You must be logged in to post a reply.
[ Cumbre de Página ] |
