GeoNames Forum

Hi,

I am facing an optimalization issue with Geonames. I have my own database (3M records, MySQL). I have a full text index on NAME and the second one on POPULATION. My query:

SELECT name FROM `geoname` WHERE MATCH(name) AGAINST ('Lo*' IN BOOLEAN MODE) ORDER BY population DESC LIMIT 10

Unfortunately, this query takes 31 seconds to get results. I wonder why.

Thanks for any tips,
Xsnowy