MySQL Forums
Forum List  »  French

Reqûete lente
Posted by: ben hakim
Date: February 16, 2007 03:59AM

Bonjour

J'ai une requête qui a un temps de réponse trés lente.
Je ne comprends pas pourquoi ?

Voici la requête:

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 Co.id = 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

Quelqu'un pourrais la critiquer et m'expliquer pourquoi ?

Je vous remerci

Options: ReplyQuote


Subject
Views
Written By
Posted
Reqûete lente
4734
February 16, 2007 03:59AM
3186
February 16, 2007 06:23AM
3421
February 16, 2007 08:35AM
3143
February 16, 2007 12:10PM
3218
February 17, 2007 07:50AM
3060
February 23, 2007 01:36AM


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.