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

Reply via email to