[OSM-dev] Namefinder - what to do

[Tom Hughes]

In message <223020e60801220443h78d1575gd1ecec230167831c at mail.gmail.com>
        Nick Black <nickblack1 at gmail.com> wrote:

> If we create an index on the way_tags k & v column we can directly
> search live data and retain the vast majority of the functionality of
> the namefinder search.  This obviously leaves the nodes being
> unsearchable.  So I'm going to look at moving node tags into a
> node_tags table.

Splitting out the node tags is good. I suspect they are quite
inefficient at the moment as they make the node records variable
length. Plus splitting them out lets us have full text indexes
on the tags although that does force us to use MyISAM for the
tags table.

> TomH: what do you think about creating a full text index on  way_tags k & v?

We already have one on v, but not k.

I've no objection to putting one on k - it will allow some more
restrictions on the search API to be lifted.

Tom

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