MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: The best bounding box selection (to show results on map)
Posted by: KimSeong Loh
Date: December 14, 2006 06:02PM

A composite index does not help much if you do range search on the both the columns. It is only good if the 1st column is equal comparison.

Try to take a look at spatial data types and index.

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


Subject
Views
Written By
Posted
The best bounding box selection (to show results on map)
3823
Joost
December 13, 2006 04:28AM
Re: The best bounding box selection (to show results on map)
1659
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)
1571
Benoit St-Jean
December 14, 2006 10:20AM
More hypothetical situation.. how to best solve this in MySQL..
1839
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.