On Sat, 27 Apr 2013 07:06:31 -0700 (PDT)
Gianni Sassanelli <[email protected]> wrote:
> I have a slow performance if i USE the view but only when i use it
> from ANDROID
I don't know if it will help, but the following query should produce
the same results and might execute faster:
SELECT id_arbox,
cdstagioni,
cdlinee,
cdbox,
ncolori,
radiato,
totalepz,
cdar,
cdtessuti,
cdcart,
case Q when 1 then cdcolori
else '-'
end as 'cdcolori'
case Q when 1 then C.descrizione
else 'ASSORTITO'
end as 'colori_descrizione'
FROM (
select id_arbox As id_arbox,
cdstagioni As cdstagioni,
cdlinee As cdlinee,
cdbox As cdbox,
nColori As ncolori,
radiato As radiato,
SUM(QTotRiga) As totalepz,
cdar As cdar,
cdarmp As cdtessuti,
cdcart As cdcart,
MIN(cdcolori) As cdcolori,
COUNT(cdcolori) As Q
from arbox
group by
id_arbox,
cdstagioni,
cdlinee,
cdbox,
nColori,
radiato,
cdar,
cdarmp,
cdcart
) as AB
JOIN Colori As C ON C.CdColori = AB.CdColori
ORDER BY
AB.cdstagioni,
AB.cdar,
AB.cdarmp,
AB.cdbox,
AB.cdcolori;
I cannot explain the behavior you reported. By mentioning the main
table only once, though, you may make it easier for the query optimizer
to do its job.
HTH.
--jkl
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
