Map bounding box

MySQL & MariaDB Other MySQL® Questions
1

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!!