Hi, I'd like to know the best way to efficiently search for names in Geoname's databases, just like it's done in geoname search API functions
I've noticed that if you search for an alternate name it finds the right place properly, so my question is what indexes/joins are needed?
And another question is how geoname's api sort/choose among results because if I do a simple fulltext query in my imported Geoname table it returns more than 10 rows, on the other hand geoname's api only return 4 places for the same query.