Mohit Sindhwani wrote: > I was wondering if there is a way that we could save space on the > R-Tree storage if the item being inserting is just a single point > (such that x1=x2 and y1=y2).
Not without changing the SQLite code. A non-leaf R-tree node must store the extents covered by all its children, so these are (n-dimensional) rectangles. At the moment, SQLite assumes that user data has exactly the same format, so such a change would not be trivial. Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

