MySQL Forums
Forum List  »  Full-Text Search

Performance of full text search varies with column length or not??
Posted by: us97013
Date: May 17, 2006 11:22AM

Hi all,

Please tell me for the same number of records (let say 1 million) whether the performance of full-text search varies with the length of a column or not on which full text search is applied?

For example, for an item to search based on tags, which of the following approach is faster?

a)Make a text column of 2048 characters at most and add all the tags for a particular item in the same column separated by commas (it means there could be maximum of 128 tags of 15 character each that can be stored for an item). Table would be something like this:

Table_Item(ItemId INTEGER, Tags TEXT => Full text search here)

and so there will be only one record for each item.

b) Instead of above approach store separate tags in separate rows and Tag column is at most 64 character long as follows:

Table_Item (ItemId INTEGER, Tag VARCHAR(64) => Full text search here)

There will be as many records for a particular ItemId as there are number of tags for it.

So please tell me which approach is better.

Thanks,

Arsalan

Options: ReplyQuote


Subject
Views
Written By
Posted
Performance of full text search varies with column length or not??
6873
May 17, 2006 11:22AM
6384
September 21, 2006 05:45AM
4423
September 21, 2006 09:05AM
3649
December 04, 2008 12:28AM


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.