Re: [sqlite] rtree extension question

On 6/11/08, Christophe Leske <[EMAIL PROTECTED]> wrote: > > 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

Re: [sqlite] rtree extension question

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

Re: [sqlite] rtree extension question

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. On 6/9/08, Shane Harrelson <[EMAIL PROTECTED]> wrote: > > Each pair of columns (min/max) represents one dimension. So for > latitude/longitude coordinates

Re: [sqlite] rtree extension question

Each pair of columns (min/max) represents one dimension. So for latitude/longitude coordinates you would have 5 columns: 1 id column and 2 columns each for latitude and longitude. 5 "columns" equates to 2 dimensions of data. 7 "columns" equates to 3 dimensions of data. Etc. HTH. -Shane On

Re: [sqlite] rtree extension question

> You can improve performance (space/speed) a little by changing the > RTREE_MAX_DIMENSIONS at the top of rtree.c to match you data set. It > defaults to 5 dimensions, but you could reduce to this to 2, or 3 with city > size. > > #define RTREE_MAX_DIMENSIONS 5 > Hi Shane, thanks for the

Re: [sqlite] rtree extension question

You can improve performance (space/speed) a little by changing the RTREE_MAX_DIMENSIONS at the top of rtree.c to match you data set. It defaults to 5 dimensions, but you could reduce to this to 2, or 3 with city size. #define RTREE_MAX_DIMENSIONS 5 -Shane On 6/9/08, Dennis Cote <[EMAIL

Re: [sqlite] rtree extension question

Christophe Leske wrote: > > - one can somehow index the fields of an rtree table, and if so how? > - if there could be any other information in an rtree table other than > the integer ID and then the real values for the rectangles. > > The reason i am asking for this is because this yields to

[sqlite] rtree extension question

Hi, i am now using the rtree extension in my project, yet still see some slowdown for some scenarios (especially for searches in narrow/small rectangles). I was therefore wondering if... - one can somehow index the fields of an rtree table, and if so how? - if there could be any other