Announcement

Announcement Module
Collapse
No announcement yet.

using filesort, bad thing here?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • using filesort, bad thing here?

    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
Working...
X