Tagged Questions
1
vote
0answers
88 views
Why do we need myisam spatial extension anyway?
If just to determine whether a point is within a rectangle,
What is wrong with this query?
EXPLAIN SELECT DISTINCT
TB.ID,
TB.Latitude,
TB.Longitude
FROM
TableBusiness AS TB
WHERE
...
0
votes
0answers
144 views
Nearest neighbor search for 1.6 million points in myisam mysql
Say I want to find 20 closest business near me. Latter I want to see the next 20 closest, etc. Yes I have myisam. I have spatial indexes on the point. I am looking for actual command.
Note:
I am ...
1
vote
1answer
134 views
What is the SQL command to get 20 closest points from some center location
There are 1.6 million rows.
Must not compute distance for all rows.
Spatial index is available
This is the table structure. The name of the table is businessauxiliary. So yes I used MyIsam, added ...
1
vote
2answers
492 views
How do I get spatial index feature if I mainly use innodb?
My current strategy is to create another table in myisam that contains those spacial information. Then if I want to find 20 closest business, I'll just use join.
Is this a good idea?
