-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Ian Dees schreef: > On Wed, Oct 8, 2008 at 9:27 PM, Stefan de Konink <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > I have a way table, that has a primary key {wayid}. The table way_tags > point to that wayid. > > > Do you ever do a lookup by tag key name? If not, then you don't need to > normalize the tags into their own table like that, just encode them > somehow into a text blob column in the way table.
No way! The database[1] uses indexing under the hood automatically. So every created_by k or JOSM v is automatically indexed. This gives a significant space reduction plus fast lookup. Next to that it is very easy now to do lookups like done in OSMXAPI, which I wrote my own implementation for. Stefan [1] http://www.monetdb.org/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEAREKAAYFAkjtbgoACgkQYH1+F2Rqwn1ORwCfYIP03zI1XqslqNp17eyx/wMJ xv4AnRuleSRPCgfpIhgfh03nPN672ce4 =stIk -----END PGP SIGNATURE----- _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
