21.5. Summary
Full-Text runs as a separate service in on the SQL Server box and takes up a separate block of memory. Be sure to keep both services in mind when planning how much memory your system needs, and also when establishing the amount of memory used by either service.
When you implement Full-Text, also consider the load the population process is going to place of your server, and balance that against how quickly you need changes reflected in search results. If possible, delay repopulation of full-text indexes until the non-peak hours on your system
Full-Text Search is a powerful and fast way of referencing the contents of most any character-based columns. It is substantially more efficient and powerful than a LIKE clause but comes with additional overhead in terms of both space and processing time.
Get Professional SQL Server™ 2005 Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
