W3bbo said:Matthew van Eerde said:*snip*What about creating an index for each dimension, then you can do linear-or-better search on the indexes for each dimension to get the desired result; this also allows for finding points in space within a specified radii of the search point too. I assume you could get your RDBMS to maintain the indexes for you.
Unless I'm missing something?
I'm talking about thousands of dimensions, there are tricks for low dimensional spacial data, but they kind of become crap at higher dimensions. Every RDBMS I've looked at can only handle 4 dimensions at most.
