Wilson, Ron P schrieb: > I'm not a guru yet, but I think you are not using the latlon index in > your query. Perhaps if you index on lat and lon separately your query > will use those indices. I think the lines below indicate using the > indices on class_dds and rowid. >
Thanks to everyone who responded, i got some pretty good feedback. Thanks also for the tiling hint, but my application is already written, and I have to stick to the databse given. I might reconsider though if the performance is still bad. Can someone tell me what kind of performance one is to expect from a 40Mb Sqlite database like the one I have? -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users