2
Contributors
1
Reply
2
Views
8 Years
Discussion Span
Last Post by mwasif
0

Hi Naveen,

MySQL FULLTEXT search works well with small data but as data grows the performance starts decreasing. Did you try MySQL query cache? This will work for you a bit if your table does not change frequently.

You can go either for Lucene or Sphinx for quick FULLTEXT searching, both can fulfill your needs.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.