On Tue, 2008-01-22 at 16:25 +0000, Nick Black wrote:
> On Jan 22, 2008 4:05 PM, Tom Hughes <[EMAIL PROTECTED]> wrote:
> > In message
> <[EMAIL PROTECTED]>
> > Nick Black <[EMAIL PROTECTED]> 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.
>
An update to the planet dump code will also be required. The code should
be a clone of what we do already for the ways tags. Please remind me to
take a look when the changes occur.
Jon
_______________________________________________
dev mailing list
[email protected]
http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
