Tagged Questions
0
votes
0answers
50 views
Spatial Database over smaller rectangle takes longer
I have to be very careful here. Both queries are so similar that the only different is the area searched.
What's surprising is the query that run on BIGGER AREA, and naturally yield MORE ROWS, is the ...
0
votes
1answer
113 views
How to interpret explain sql?
SELECT DISTINCT TB.ID, TB.Latitude, TB.Longitude, 111151.293413 * SQRT( pow( - 6.185 - TB.Latitude, 2 ) + pow( 106.773 - TB.Longitude, 2 ) * 0.988392289802 ) AS Distance
FROM `tablebusiness` AS TB
...
-2
votes
1answer
783 views
Why does MATCH (FullTextSearch) AGAINST ('*' IN BOOLEAN MODE) return nothing?
MATCH (FullTextSearch) AGAINST ('k*' IN BOOLEAN MODE)
return something
Namely anything with a word that start with k
MATCH (FullTextSearch) AGAINST ('ku*' IN BOOLEAN MODE)
return less
MATCH ...
0
votes
0answers
140 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 ...
