Solved

Full Text Indexing and Overhead

Posted on 2014-11-03
3
335 Views
Last Modified: 2014-11-08
Hi
I'm looking for info on the amount of overhead associated with building a search feature that employs full text search / indexing.
And is this too much overhead and what are the considerations to determine what is too much overhead.
I say this because the DB guys say that it is high in overhead.

Sql server 2012

Thanks
0
Comment
Question by:dgrafx
3 Comments
 
LVL 46

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 150 total points
ID: 40421042
Like everything, if isn't well configured you can have performance issues.
Did you read the MSDN article about Full Text Performance?
0
 
LVL 26

Accepted Solution

by:
Zberteoc earned 350 total points
ID: 40430216
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS SQL - Rotating Values in SQL 9 53
Managing Columnstore Indexes 2 18
TSQL - IF ELSE? 3 29
How to use Full Text CONTAINS with Case in SQL 6 20
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now