On 02/01/2008, Stefan de Konink <[EMAIL PROTECTED]> wrote: > Tom Hughes schreef: > > On 02/01/2008, Stefan de Konink <[EMAIL PROTECTED]> wrote: > > > >> 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 > > > > ...this would be a setup that has a name field in way_tags? unlike the > > actual live setup which doesn't? > > Yup. Does the live setup store it as 'bla=bla'?
No - it has columns called k (key) and v (value). That's for ways - nodes store it all jumbled up in a single field. Tom -- Tom Hughes ([EMAIL PROTECTED]) http://www.compton.nu/ _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
