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 PROTECTED]> wrote: > > Christophe Leske wrote: > > > > But since it needs min and max sizes, i am effectively tripling the data > > needed for requests: > > Yes, that will happen. It would be nice if the R-Tree records could > handle points without the redundant storage of duplicate data for each > dimension. Maybe Dan will get to that someday. > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users