Follow me on Twitter at Twitter.com/wbm
FYI, I'm blogging most of my stuff over at More Wally now.
You might want to add my rss feed to your reader at:http://morewally.com/cs/blogs/wallym/rss.aspx
Full-Text Search with Yukon - Wallace B. McClure

Wallace B. McClure

All About Wally McClure - The musings of Wallym on Web, HTML5, Mobile, Xamarin.iOS, Xamarin.Android, and Windows Azure.

News

Visual Studio Magazine Column Personal Blog

.NET

Book Authors

Business

Family

Friends

Georgia Tech Bloggers

Personal

Archives

Full-Text Search with Yukon

While I as sitting here fiddling with things this evening, I decided to do a little test to see just how well full-text search worked in Yukon.  Man, I was blown away.  Granted I don't have millions of rows in my table to search through, but I do have a system with about 70,000 rows setup for full-text search and am adding them at the rate of about 40 URLs per minute (hey I am bandwidth constrained at my office).  I decided to do a full-text lookup for 'President Bush' on the Yukon database while simultaneously runing the spider and having already setup a full-text index in Yukon.  In just a few seconds, I got about 200 rows back.  Doing this same test on my other system that is running Sql Server 2000 and is taking hours to build the full-text index resulted in a query that took several orders of magnitude longer to search a table with about 700,000 rows in it.  Now, I realize that this is not a fair comparison for several reasons.  Once the full-text index is built on my Sql Server 2000 system, I am going to run a comparison.  No, I am not going to post the complete results.

Here is the sql statement I ran:

select * from tblSearchResults where contains(SearchText, '"President Bush"')

Full-text search with Yukon.

Wally

Comments

No Comments