MySQL Forums
Forum List  »  Performance

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
More hypothetical situation.. how to best solve this in MySQL..
1838
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.