Slow answer when using ORDER BY

[kennet andersson]

I have two tables and want to return artists that begins with A,B,C and D

If I use ORDER BY it takaes about 10 times longer to execute compare to not using ORDER BY.


SELECT medialib.guid, medialib.artist, medialib.title
FROM songstation
INNER JOIN medialib ON ( songstation.songguid = medialib.guid )
WHERE (
songstation.stationguid = 'ffeeaab6-9558-4c85-9fc8-27e962d47ec7'
)
AND (
medialib.artist LIKE 'A%'
OR
medialib.artist LIKE 'B%'
OR
medialib.artist LIKE 'C%'
OR
medialib.artist LIKE 'D%'
)

ORDER BY medialib.artist

LIMIT 0 , 30



I have tested BETWEEN, but the result is the same, slower when using ORDER BY.

Any suggestions??



Edited 1 time(s). Last edit at 03/15/2009 07:58AM by kennet andersson.