Tagged Questions
2
votes
1answer
302 views
How to speed up this simple MySQL points in the box query
MySQL doesn't have nearest neighbor search so. So I try to come up with a "distance" that's reasonable so the number of returned query is around 20-200.
That way innodb doesn't have to compute ...
7
votes
3answers
1k views
how to find 20 closest points efficiently
Say I want to find 20 closest business near me.
My table structure is like this:
BusinessID varchar(250) utf8_unicode_ci No None Browse distinct values Change Drop ...
8
votes
4answers
673 views
Fastest spatial storage format?
I am wondering what storage method will result in the fastest reading of the map vectors for rendering. SHP? PostGres? SQLite? (They do not change often and I do not need spatial functions for these ...
7
votes
3answers
2k views
Poor Performance when using Spatial Indexes in MySQL
Re-post of a question asked on Stack Overflow when it was suggested this would be a better forum.
I'm trying a little experiment at pushing a data set which is not geo-spatial but fits it quite well ...
