Lucene.NET vs SQL Server Full-text – Generating a million records and a full-text index
Posted
on Dot net Slackers
See other posts from Dot net Slackers
Published on Wed, 28 Oct 2009 00:00:00 GMT
Indexed on
2010/03/07
23:28 UTC
Read the original article
Hit count: 693
Filed under:
In this article we will take a look at how SQL Server performs with one million records in a table. We will create a quick data pumper program to fill up a table with a million dynamically created rows of data. From there we will take a look at querying the data without any special optimizations. Then we will create a Full-text index and see how that helps our searching capability.
© Dot net Slackers or respective owner
