[Tagdb] Tags and data storage

[Philipp Keller]

> Not everyone at once, now .....  :-)
Is your quota full already? :-)

I think there are just Otis and Erik having experiences with larger
scale tag systems.

We implemented tags in our companies CMS framework.
We just implemented the obvious simple 3 table solution (with tags in
separate table of course). This has proven to be very handy. First I
thought we have to do a hybrid 3 table solution with fulltext (tags are
saved in a fulltext field as well as in a separate table) because I
thought this might be better for similarity (tag unions) searching. It
has proven that a simple 3 table schema is great for searching i.e. for
"tree OR forest". That is if the data stays small.

Ah, that's all too obvious! You know this all already. That's probably
why nobody's replying to your question. The "big guys" are all too busy
writing about their implementation details :-)

greets
Philipp