Re: Storing Keywords
Right. I would try to leave the keywords out of the records an make a second table like so:
// -- keyword -- id -- \\
john 654
john 544
john 8645
apple 654
fastfood 654
fastfood 8743
...
In principle this means indexing the original table by keywords.
Or, in other words, building a kind of index that MySQL cannot do for you because the index values are not necessarily literally contained in the data and not all words of the data shall be indexed.
A fulltext index may be a good compromise when people are lazy to assign good keywords.
Ingo
Subject
Views
Written By
Posted
7057
November 08, 2005 04:25PM
2873
November 08, 2005 08:03PM
Re: Storing Keywords
2634
November 09, 2005 04:13AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.