hi,
i have this table:
TABLE messages
id_usr, id_usuario, message, date
PRIMARY (id_usr, id_usuario, date)
the querys over this table will be always like this:
EXPLAIN SELECT *
FROM messages
WHERE (
id_usr =1
AND id_usuario =2
)
OR (
id_usr =2
AND id_usuario =1
)
ORDER BY date
LIMIT 0 , 30
that shows me:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE messages range PRIMARY PRIMARY 8 NULL 13 Using where; Using filesort
so it uses filesort, which is a bad thing, but my question is, in this case, considering that there will be at most 100 rows as response, is really important the filesort issue?
is there any other way to do that better ?
thanks a lot