Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with spatial-database
Search options not deleted
user 8257
Spatial database is a database that is optimized to store and query data that is related to objects in space, including points, lines and polygons.
1
vote
2
answers
74
views
2 Similar Queries Run at Vastly Different Speed in a Very Surprising Way
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 …
- 259
8
votes
4
answers
11k
views
how to find 20 closest points efficiently [closed]
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 Prima …
- 259
4
votes
1
answer
2k
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 distan …
- 259