As a convenience feature, a SQL Repository can simulate full text searches using the SQL LIKE operator. If full text searching is not available for your database, you can substitute pattern matching queries for text search queries by setting the following property in the GSARepository component:


The SQL Repository will then convert text search queries into CONTAINS pattern match queries, which are implemented using the SQL LIKE operator.

Simulated text search queries are useful for demos and standalone development when one wants to put in place the createTextSearchQuery() API calls without having to set up a text search engine. However, simulated text queries are extremely inefficient and are not supported for production systems. A simulated text search query using LIKE will typically cause a table scan, so you should not use simulated queries in production.

loading table of contents...