Iron Speed Designer supports integration with Full-text Search in SQL Server 2008 databases. This document describes how Iron Speed Designer makes use of full-text search.
Instructions for setting up and configuring full-text search in SQL Server can be found in the relevant SQL Server documentation. For example, searching on “house” can also yield matches on “houses”, “housing”, or even “home”. For example, when searching on a given word, full-text search not only tries to match on the given word, but can also match on forms of the given word or even on other words that have similar meaning. Querying large amounts of data using full-text search can provide significant performance gains over character-based searches as well as gains in usability.įor example, running a LIKE query against millions of rows of text data may take tens of seconds or even minutes to return whereas a full-text query can take only seconds or less against the same data.ĭoing linguistic searches instead of character-based searches also adds other levels of usability.
Unlike character-based comparisons used in SQL LIKE expressions, full-text search performs linguistic searches by operating on words or phrases. Full-text Search is an optional component of SQL Server that allows fast and efficient querying of large amounts of unstructured data.
