# Map bounding box

**URL:** <https://forums.percona.com/t/map-bounding-box/3847>\
**Category:** Other MySQL® Questions\
**Created:** [November 1, 2014, 3:10am UTC](https://forums.percona.com/t/map-bounding-box/3847 "2014-11-01T03:10:04Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ccchego](https://avatars.discourse-cdn.com/v4/letter/c/e9a140/32.png) [@ccchego](https://forums.percona.com/u/ccchego)\
**Post date:** [November 1, 2014, 3:10am UTC](https://forums.percona.com/t/map-bounding-box/3847/1 "2014-11-01T03:10:04Z")

</div>

Hi, I would really like any suggestions on the following concerning performance…:  
I have 1.000.000 locations with:

- a name
- a latitude
- a longitude
- a score  
I want to:
- select all locations on a particular (google)map. So a latitude BETWEEN (… AND …) AND longitude BETWEEN (… AND …)
- fulltext match name. So name MATCHES (…)
- ORDER BY score  
How would I get the best performance? What indexes should I create? Should I split the data in two tables and then JOIN? Or should I put everything together in one table?  
ANY help would be great!!