Re: [sqlite] Joining 2 views

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 > creati

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 >&

[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