MySQL Forums
Forum List  »  Optimizer & Parser

low query
Posted by: hakim benmouhoub
Date: February 16, 2007 03:49AM

Hi my name's hakim.

I have a problem about query. My query have a low response time.
I don't understand ?

here the query:

SELECT P.id_audio, P.note_audio, P.id_playlist, C.nom_audio, C.id_artiste, A.nom_artiste, AVG( Pl.note_audio ) AS Moyenne, COUNT( Pl.note_audio ) AS total, Co.id_compte, Co.avatar_compte, Cs.cover_support FROM playlist_user P, playlist_user Pl, catalogue_audio C, catalogue_support Cs, artistes A, comptes Co, comptes U WHERE P.id_user = U.id_compte AND U.url = 'nasty' AND P.id_audio = C.id_audio AND C.id_artiste = A.id_artiste AND Pl.id_audio = P.id_audio AND = A.id_artiste AND C.id_support = Cs.id_support GROUP BY P.id_audio ORDER BY P.note_audio DESC , Moyenne DESC LIMIT 0 , 5

somebody can explain me: how optimize that query

thank you.

(i don't write english)

Options: ReplyQuote

Written By
low query
February 16, 2007 03:49AM
February 16, 2007 04:44AM
February 16, 2007 08:28AM
February 25, 2007 11:55PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.