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 explaining in an email all the things that you have considered, tried and rejected so others may learn from it? > > 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 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? > > create temporary tables with the views, possibly index these temp > tables, then query that table. > > > > Best regards > > Günther > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
