Re: Consider further search optimization, hesitate between MySQL LIKE and ▒FULL-TEXT▓
Honestly limiting to 1,000 search results isn't as bad as it sounds. A lot of third party services (Google Commerce Search [note this product is being deprecrated] and SLI for example) do this. We do that with our search results (powered by HawkSearch) because honestly if someone is having to go past 6+ pages in a search for a product you have bigger problems then large result sets.
Note: We have about 152,000 active SKUs
|