-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Tom Hughes 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.
And we would fix the ; problem. |> 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. Surely k only needs a normal index, not a full text one. For the purposes of a name finder like thing we just need to search the values for k=name - I don't know if you can do a conditional index in MySQL. I have a feeling you can't, which means that it would have to be a separate table of name tag values. Something that would be good is an HTML page for each node or way that had an openlayers with the thing highlighted, and a list of things associated with it (either with relations, with connecting ways, or just nearby) with links. It could also "transclude" wikipedia content about the object if there is any. The idea would be that search engines would spider it and when someone searches for something we would be in the results. Robert (Jamie) Munro -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHlh3ez+aYVHdncI0RAtv/AJ4xXbKIc6O07sOWCbqgdWRMi4KGKACeN1lU XM0VBgOwN6UICUfhw2w68e4= =OPXb -----END PGP SIGNATURE----- _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
