Originally Posted by Old Pedant
UGH! VERY VERY BAD!
WHY are you using nick to join the two tables????
For that matter, WHY are you using nick in the COMMENTS table *AT ALL*!!!
You should REPLACE the nick field in COMMENTS with user_id and make it a FOREIGN KEY to the id field in USERS table.
But anyway, the reason it is so slow is that nick is NOT AN INDEX in your COMMENTS table!!!
hm... is that so problem ? with the nick... ? :/ btw
but i have index on comments.status_id and i am using it here
WHERE c.status_id IN (3398,3342,3129,2895,2157,2072,2062,1995,1945,1915)
or its useless? rather on nick ... or can i use it on both?
BTW the speed now :
Found rows: 53 Warnings: 0 Duration for 1 query: 0.015 sec. */