Introduction
Search is where a lot of ColdFusion applications quietly fall over. It starts with WHERE product_name LIKE '%#form.q#%', which works fine on 5,000 rows and becomes a full table scan on 5 million. Then someone asks for relevance ranking, typo tolerance, faceted filters and highlighted snippets, and LIKE has nothing left to offer.
Read More