Shane Harrelson schrieb: > Were you able to try this Christophe? I expect it to only be a very slight > performance improvement, but I'm still curious as to how much. > Shane,
thanks for getting back to me for this, but I haven´t tried this yet. I will do so now. However, i need 7 dimensions now in my rtree class, as i added the size of the city to the rtree table (along with lon and lat) My setup is somewhat special, in that i am using the sqlite3 command line interpreter for querying the database and then retrieving the info via stdout. I was also busy investigating a crash that occured when using the rtree extension under Windows Vista - it seems as if there is a path size limit and/or path character issue in sqlite3. My client was using a long, convulated path to the directory holding the database and extension, and the app kept crashing although it worked here for me on my Vista machine. Moving the app to a root folder of the disk fixed the issue apparently. I got several questions regarding this: - what is the path length imposed in sqlite for extension loading? - are there any special characters not to use in a path to an extension? - are there any special switches one is supposed to use for Vista compilation of the rtree extension? - what is the scheduled publishing date (if any) for Sqlite 3.6 in which the rtree extension is supposed to be part of the standard distribution? I´d rather prefer to use an official build of the rtree than mine, as I am having trouble to get consistent file sizes when compiling the rtree.dll. Strangely enough, the first version that actually worked of the rtree dll is just 25Kb in size. Any other attempt since then to compile a release version of the dll always resulted in a clearly bigger filesize, like 80Kb. Smallest i am getting now is about 60Kb, and i can´t figure out what I did, as this is exactly the same source code, minus the manifest file. But even by readding it, the resulting dll is always bigger... -- 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
