[php] SELECT optimieren??? (eventuell OT)

[=?iso-8859-1?Q?Christian_Sch=E4fer?=]

hi,

ich habe folgende SELECT-QUERY und die liefert mir eine Maximum execution
time...
kann man die noch optimieren?

SELECT artist.id, artist.name, audio.id, audio.user_id, audio.artist_id,
audio.title, audio.format, audio.genre, audio.year, audio.label,
audio.length, format.*, genre.* FROM artist, audio, format, genre WHERE
audio.artist_id = artist.id AND artist.name LIKE '%accessory%' AND
audio.format = format.id AND audio.genre = genre.id ORDER BY artist.name
ASC, audio.year DESC

gruß
christian


_________________________________________________________
Do You Yahoo!?
Get your free _(at)_yahoo.com address at http://mail.yahoo.com