[OSM-dev] Anyone with a speedy gazetteer

[Tom Hughes]

Erik Johansson wrote:

> I have two questions; why is gazetteer.openstreetmap.org so slow  at
> 20-50 seconds per request, and if anyone has code for faster variants
> of name finders? Speed is essential..

Because it's a pile of PHP code that is hardcoded to use MySQL as the 
backend and which uses MyISAM tables in an environment to which they are 
not at all suited.

As I have explained a number of times, in order for the current 
namefinder technology to have any chance of working properly the 
following things need to happen:

   - All tables need to be switched to InnoDB

   - A query timeout needs to be implemented to abort long
     running queries

Switching to PostgreSQL would probably be even better.

Once the above things are done we will be able to see whether the 
current schema/technology are actually workable or not.

Tom

-- 
Tom Hughes (tom at compton.nu)
http://www.compton.nu/