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?
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
