Skip navigation links

MySQL Forums :: Performance :: The best bounding box selection (to show results on map)


Advanced Search

More hypothetical situation.. how to best solve this in MySQL..
Posted by: Joost ()
Date: December 15, 2006 02:19PM

Let's make it more hypothetical..this is the problem I want to solve:

- I have 'entries' (businesses etc..)
- Each has several 'tags'
- And a location (latitude / longitude)

I want to create a search like on www.yelp.com. This means:
- Search within map area
- Order on some kind of score
- Match certain tags..

What is the best way to do this? Where should I put everything & what indexes could I create best?

The only thing I have till now (that works great):
- Tags are saved in a TEXT field. The selecting is done using a FULLTEXT MATCH in boolean mode. So an entry tagged with 'car' and 'garage' gets a field 'car garage' on which it is fulltext matched..

But what is the best way to create the rest?

Options: ReplyQuote


Subject Views Written By Posted
The best bounding box selection (to show results on map) 2654 Joost 12/13/2006 04:28AM
Re: The best bounding box selection (to show results on map) 1268 Joost 12/14/2006 02:20AM
Re: The best bounding box selection (to show results on map) 1184 KimSeong Loh 12/14/2006 06:02PM
Re: The best bounding box selection (to show results on map) 1207 Benoit St-Jean 12/14/2006 10:20AM
More hypothetical situation.. how to best solve this in MySQL.. 1478 Joost 12/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.