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. > > 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 ([EMAIL PROTECTED]) > http://www.compton.nu/ > > _______________________________________________ > dev mailing list > [email protected] > http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev > -- Nick Black -------------------------------- http://www.blacksworld.net _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
