[OSM-dev] Automatic Spell check service
Stefan de Konink
skinkie at xs4all.nl
Wed Jan 2 19:15:58 GMT 2008
Tom Hughes schreef:
> On 02/01/2008, Stefan de Konink <skinkie at xs4all.nl> 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.
More information about the dev