Re: [sqlite] LOW performance with VIEW and ANDROID

2013-04-27 Thread James K. Lowden
On Sat, 27 Apr 2013 07:06:31 -0700 (PDT) Gianni Sassanelli 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, cdstagion

[sqlite] LOW performance with VIEW and ANDROID

2013-04-27 Thread Gianni Sassanelli
Hi experts, i'm using a SQLLITE for my ANDROID APP I have a slow performance if i USE the view but only when i use it from ANDROID the scenario is the following: I have a table defined as CREATE TABLE ArMpCol ( Id Integer PRIMARY KEY, Id_Ar int, Id_ArMpCol int, C