MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: The best bounding box selection (to show results on map)
Posted by: Joost
Date: December 14, 2006 02:20AM

Tip1:
- Create two INDEX's on your latitude and longitude columns. MySQL chooses between these to..
- A (latitude, longitude) INDEX does not seem to work..

Who can give me a second tip :)

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
The best bounding box selection (to show results on map)
3819
Joost
December 13, 2006 04:28AM
Re: The best bounding box selection (to show results on map)
1657
Joost
December 14, 2006 02:20AM
Re: The best bounding box selection (to show results on map)
1589
KimSeong Loh
December 14, 2006 06:02PM
Re: The best bounding box selection (to show results on map)
1570
Benoit St-Jean
December 14, 2006 10:20AM
More hypothetical situation.. how to best solve this in MySQL..
1837
Joost
December 15, 2006 02:19PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.