[OSM-dev] Namefinder - what to do

[Nick Black]

On Jan 22, 2008 4:05 PM, Tom Hughes <tom at compton.nu> wrote:
> 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?

Ok, so we can roll creating node_tags, migrating from nodes.tags to
nodes_tags and a k + v full text index into one set of
uber-migrations.

>
> 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/
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
>



-- 
Nick Black
--------------------------------
http://www.blacksworld.net