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. > > I am interested in the inner workings of SQlite in order to get it to > know better, not to rant about it... > You might want to read some of these pages: Architecture: http://www.sqlite.org/arch.html (Old) VDBE tutorial: http://www.sqlite.org/vdbe.html Optimization: http://www.sqlite.org/optoverview.html Performance: http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuning There used to be a good set of slides from a presentation Dr. Hipp gave at http://www.sqlite.org/php2004/page-001.html but they seem to have disappeared from the internet. Fortunately, the wayback machine still has a copy at http://web.archive.org/web/20041230195828/http://www.sqlite.org/php2004/page-001.html HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
