List:General Discussion« Previous MessageNext Message »
From:zzapper Date:December 13 2005 4:52pm
Subject: full text search
View as plain text  
Hi,
I've always done conventional searches Where ( title like '%$key1%') or(isynopsis like
'%$key2%')
etc etc

But the client has increased the complexity of the search and especially the size of his
database
and the search has really slowed. (particularly now that I have to search a longtext
field.)

So should I consider fulltext searching?

Do I have to build an index first and how often is it updated etc?

-- 
zzapper
Success for Techies and Vim,Zsh tips
http://SuccessTheory.com/

Thread
full text searchzzapper13 Dec
  • Re: full text searchGleb Paharenko13 Dec