> No, again SQLite doesn't know anything about the rectangles your > application is using to build the queries, only your application knows > that. > So that Sqlite database is pretty fast, but quite stupid, hu?
Naaa, just kidding. Thank you for the very informative email you sent. I already added the class size of the city to the rtree. But since it needs min and max sizes, i am effectively tripling the data needed for requests: since i got only points (lon/lat) for my cities, i enter the same values twice (e.g. for longitude_min, longitude_max, latitude and class the same). I am interested in the inner workings of SQlite in order to get it to know better, not to rant about it... It is a cool tool I am using in many projects. -- 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
