View Single Post
  #12  
Old 06-11-2013, 11:40 AM
  Jon's Avatar 
Jon Jon is offline
 

X-Guru
  
Join Date: Oct 2002
Location: Vancouver, Canada
Posts: 4,200
 

Default Re: Consider further search optimization, hesitate between MySQL LIKE and ▒FULL-TEXT▓

Quote:
Originally Posted by cflsystems
Anything you can do to increase speed and provide better search in XC is good. As others mentioned some of the limitations are not relevant
- search that returns 5000 results is as bad as the one that returns 1000 - either way I will not go through all these pages;
- if anyone is looking for "apple" and tries to search for it with "pple" deserves not to find anything
- the 4 symbols may be a troubled (as your example "cat") but still not a stopper especially if it can be changed

The way I had coded this before, is that if the term is less than 4 results it would do a like search and 4 or more it would do full text.
Reply With Quote