Fwd: [Tagdb] tags in separate table

[Zbigniew Lukasiak]

---------- Forwarded message ----------
From: Zbigniew Lukasiak <zzbbyy at gmail.com>
Date: Oct 12, 2005 5:21 PM
Subject: Re: [Tagdb] tags in separate table
To: Michal Migurski <mike at teczno.com>


On 10/12/05, Michal Migurski <mike at teczno.com> wrote:

> It's more efficient and more extensible to search for entities-by-tag when
> tags have their own table. The relationships are fully bidirectional that
> way.
>
> The only way to do this if the tags are stored as a field in an entity is to
> use a pattern match or a full text search, both of which are expensive and
> hard to manage. I've heard that early versions of Del.icio.us used the MySQL

I think you misunderstood my question.  I did not mean multiple tags
in one field, where you need full text search, this would be not a
relational design.  What I meant was a indexed column for one tag.
The only question  in efficiency is what is the difference  in
efficiency between an index on integer column and index on a char
column.  I assume integers would be faster but is that a practical
difference?

-- zby