search

datazuul / jbal

Automatically exported from code.google.com/p/jbal
0 stars 0 forks source link

performance orderby #10

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
vedere se 
createIndex(conn,"ricerche_dettaglio_idx1", "ricerche_dettaglio",
"id_ricerca");
in mysql.createTableRicerche
ha senso o meno

desc 
select n.id,t.testo 
from notizie n ,ricerche_dettaglio rd,tit_ndx t  
where 
rd.id_notizia=n.id and 
t.id_notizia = n.id and 
rd.id_ricerca=1 
order by t.testo;

Original issue reported on code.google.com by albert.c...@gmail.com on 14 Apr 2009 at 1:32