The SQL LIKE operator can be used to perform free form searches against text in table columns. But LIKE is not fast, especially if searching for sub-strings (using wildcards at the start of the search text). For faster full text searching use ColdFusion’s integrated Verity engine which can be used to index the text in tables. Subsequent Verity searches can return the primary key of matching database records for immediate retrieval. This does involve using both and (instead of just ), but the performance gains can make the effort well worth your while. (Applies to: ColdFusion All)

Leave a Reply