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). > > Does anybody here know a solution to this problem?
What are the view definitions and what query are you running? It may be that you can add an index to one of the underlying real tables that will help. Dan. > Best regards > > Günther > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users