Tom Hughes schreef: > On 02/01/2008, Stefan de Konink <[EMAIL PROTECTED]> wrote: > >> I wonder if it could be accepted that every day an automatic spell check >> script would operate on the database and checks for less common 'name' >> tags for automatic spelling corrections. >> >> select name, count(name) AS count from way_tags group by name order by >> count, name; > > That query should only lock the API for an hour or so at a guess.
In my setup: 89696.395 msec resulting in 10434 rows Yes, it isn't MySQL, don't worry, the machine has 8GB of memory and only costed 390 euro. Would it be better if I provide a list of suggestions and that this is applied to the database via the API or something faster? I'm now creating a query that just checks the most common words on common operations (the easy fixes). Typo's will come afterwards. Stefan _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
