Re: Reqûete lente

[ben hakim]

Voilà la commande effectuée:

 table  type  	possible_keys  	 key  	 key_len  ref  	       rows  Extra
Co 	ALL 	NULL 		 NULL 	 NULL 	  NULL 	       458   Using temporary; Using filesort
Pl 	ALL 	NULL 		 NULL 	 NULL 	  NULL 	       768 	 
A 	eq_ref 	PRIMARY 	 PRIMARY  4 	  Co.id        1 	 
P 	ALL 	NULL 		 NULL 	 NULL 	  NULL 	       768   where used
C 	eq_ref 	PRIMARY 	PRIMARY  4 	  P.id_audio   1     where used
Cs 	eq_ref 	PRIMARY 	PRIMARY  4 	  C.id_support 	1 	 
U 	eq_ref 	PRIMARY 	PRIMARY  4 	  P.id_user 	1     where used
where used

J'espere que cela pourra vous aider.
Merci