MySQL Forums
Forum List  »  Full-Text Search

Re: Performance of full text search varies with column length or not??
Posted by: Apachez
Date: July 01, 2006 12:17PM

If the tag is a single word, say for example that your tags are names of cities (city), then I think its faster to have an approach that have one city and itemid per row and then an index on the city column. To shrink the index size you can perhaps index only the first 6 chars or so. This way you will basically have a direct access when you perform a query such as:

SELECT itemid FROM t1 WHERE city = 'name';

In other terms no need for fulltext indexing.

But I have perhaps misunderstood what your tags actually are ?

Perhaps you can give some example data ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Performance of full text search varies with column length or not??
3920
July 01, 2006 12:17PM
6379
September 21, 2006 05:45AM
4418
September 21, 2006 09:05AM
3643
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.