Re: [sqlite] Joining 2 views

On Oct 14, 2008, at 4:39 AM, Guenther Schmidt wrote: > Hi, > > unfortunately I've hit a point where I run a query where one VIEW > joins > another VIEW. > > Both views are rather large and since there is no index on the fields > where they join the query takes very very long. (About 15 min). >

Re: [sqlite] Joining 2 views

Hi P, well I tried to put all the business logic out of my program and into views. Basically all my program does is feed data into tables that are created for dynamic data and are cleaned before each import. Once the import is finished my app then selects from those views. Those views use

Re: [sqlite] Joining 2 views

On 10/13/08, Guenther Schmidt <[EMAIL PROTECTED]> wrote: > > Hi P, > > thanks, I had considered that. > > Hope there is another solution though. possibly, but how about enlightening others as to why you considered creating temp tables and then decided not to do so? In fact, how about

Re: [sqlite] Joining 2 views

Hi P, thanks, I had considered that. Hope there is another solution though. Günther P Kishor schrieb: > On 10/13/08, Guenther Schmidt <[EMAIL PROTECTED]> wrote: > >> Hi, >> >> unfortunately I've hit a point where I run a query where one VIEW joins >> another VIEW. >> >> Both views are

Re: [sqlite] Joining 2 views

On 10/13/08, Guenther Schmidt <[EMAIL PROTECTED]> wrote: > Hi, > > unfortunately I've hit a point where I run a query where one VIEW joins > another VIEW. > > Both views are rather large and since there is no index on the fields > where they join the query takes very very long. (About 15 min).

[sqlite] Joining 2 views

Hi, unfortunately I've hit a point where I run a query where one VIEW joins another VIEW. Both views are rather large and since there is no index on the fields where they join the query takes very very long. (About 15 min). Does anybody here know a solution to this problem? Best regards