Tagged Questions
1
vote
0answers
22 views
How to make some constraint to be evaluated first in mysql?
SELECT BusinessID
FROM
tableauxiliary
WHERE
MBRContains(
GeomFromText (
'MULTIPOINT(-6.1928749092968 106.7651250907,-6.1771250907032 106.7808749093)'
),
...
2
votes
1answer
334 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 ...
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 ...
