Jason Salas' WebLog

On-air and online: making people laugh, making people think, pissing people off

Sponsors

ASP.NET sites that kick ass

Pals with blogs

Podcasts I listen to

Technical pet peeve: no search services are better than weak search services

The one thing that's really been irking me in using the web lately is poor search utilities.  And this is regardless of the platform the site was developed with.  Nothing get me more steamed these days than browsing to a content-rich site, looking for an article, code snippet, or other content and getting bad and unhelpful search results. 

On one such site today, I even copy-and-pasted the name of the article I was looking for into a textbox and searched for it to no avail - “Your search returned 0 results”.  Yecch.

This is the direct result of metasearch services like Google, Dogpile and AllTheWeb.com others taking off - people expect more from individual sites.  And they have every right to.  Those of us not at that level likely can't provide similar functionality as those tools, but we could at least allow a user to search our own content effectively.

Think about it: search facilities are functionally the easiest things a web developer can build, but realistically one of the most challenging – if not the hardest - things to do right and maintain on a content-rich site.

My point is that having weak search services - and services in general, for that matter - is poor customer service and therefore detrimental to your image (assuming you're concerned about that sort of thing).  And this is seen in major sites, from major companies, offering content that should be its nature be (1) indexed constantly (2) accessed by a powerful, flexible, intelligent search service.  This is a no-brainer, but why people on today's intelligent web continue to provide hard-to-use and even worse, poorly-performing search facilities amazes me. 

Having a simple SQL-based LIKE '%searchString%' statement doesn't cut the mustard these days.  You'll arrive with incredibly inflated recordsets and ill-formed results.  Steve Walther has what in my opinion is the best discussion on developing effective search tool in his classic “ASP.NET Unleashed“, showing how easy it us to use to use Full-Text Indexing, and SQL Server's FREETEXT and FREETEXTTABLE functions.  I'm not sure why more people haven't gravitated toward this end, weighing the gains against the efforts.

And I'm only ragging on those who've continued to have weak search capabilities, because I was there myself once. I used to run the Search utility that shipped with FrontPage several years ago to manage my site's content, but that got really old, really fast.  We now use a simple web form that outputs results off of Google, specific to our site, and we couple this with a database-driven Keyword Search utility based off of a web service we developed that works like those found on AOL or ESPN (we tease keywords to use throughout our broadcasts, so we have a bit more control over the ambiguity of our searches). 

It used to be written constantly in online marketing journals that the key to winning on the web is having a search utility.  I'd like to add a corollary - if you haven't got great search services, remove them altogether.  Better to be lacking such a feature and have a decent alibi than be sorely inferior with a justifiable motive.   Most people will use search engines anyway.

Comments

TrackBack said:

# February 11, 2004 4:37 AM

Wallym said:

Jason,

The reason that I see why they aren't using FreeText and such is that MS's fulltext engine in Sql2k is not very good. It takes an amazing effort on the part of the CPU to get it working. Yukon's full text engine is suppossed to be much improved.

Wally
# February 11, 2004 5:46 AM

Derick Bailey said:

The actual indexing may take some cycles, but it only happens on the schedule that you set. Any good DBAmin should know how to setup the schedule to run during the lowest traffic times, and create a good fulltext index for searching.

As for the actual fulltext searching in SQL Server 2K, it's actually part of Indexing Service that gets called to do the searching. If someone complains about SQL 2K fulltext, but also uses the Indexing Service, then that person is full of crapp.

I personally think that the fulltext searching in SQL2K is quite nice. But then, I actually spent a few minutes to write a query parsing engine that builds proper fulltext search queries based on user input.
# February 11, 2004 9:24 AM

TrackBack said:

# February 11, 2004 10:53 AM

Jason Salas said:

Hi guys,

Good thoughts. I'm pondering moving to FTI myself, but in doing so I'll need to migrate the entire SQL Server DB we use now (only about 9,000 records, with multiple NTEXT fields) to a different database server.

Has anyone seen any creative alternatives to using a good classical search?
# February 11, 2004 6:59 PM

Sassy said:

Fulltext searching on SQl2k is a pathetic joke. Not because of CPU cycles, because it _simply _dont _work. Once again, garbageware from Microsoft
# June 23, 2004 6:33 PM

TrackBack said:

<p>Admittedly, I haven't used full text search on SQL 2000.<br />
But I am sure DBSight can beat it.</p>
<p>I have seen posts like this<br />
<a href="http://weblogs.asp.net/jasonsalas/archive/2004/02/11/71130.aspx">Technical pet peeve: no search services
# April 14, 2005 11:56 AM

KonnienL said:

Very good topic referring to this post. One can check the article at the papers writing service and <a href=" http://www.supremeessays.com">buy essay</a> and already written essay done by essay writers.

# December 27, 2009 2:40 AM

essays said:

if you have any problems with education,buy <a href="http://uk.bestessays.com">essays</a>,it will help in learning and save your time

# July 5, 2010 10:08 AM

essay writing services said:

You do not have to get all the pressure of research papers finishing simply because famous academic papers writing companies are able to rid of your stress proposing you to buy essays and it's perfect, I guess!

# August 22, 2010 9:21 AM

online writing jobs said:

<a href="www.writers.ph/">online writing jobs</a> will help you get extra money in spare time.

# October 24, 2010 6:07 AM

Stopping Smoking said:

"I completely concur using the over opinion, the globe vast internet is certainly without a doubt expanding in to the main sort of conversation close to the planet and  it's because of to internet websites like this that ideas are spreading so swiftly."

--------------------------------------------

my website is  

http://flying-v-guitar.com

Also welcome you!

# November 20, 2010 2:34 AM

bad credit said:

I read it and I think this work can be done and it is workable.

# December 8, 2010 7:54 AM

ipad accessories griffin said:

Never underestimate your power to change yourself!

-----------------------------------

# December 19, 2010 10:47 AM

online degree said:

I am pleased to read your article.

# December 21, 2010 1:44 AM

ipad specs review said:

Wasting time is robbing oneself.

-----------------------------------

# December 24, 2010 12:05 PM

ipad app reviews said:

-----------------------------------------------------------

"Have you ever regarded as adding much more movies for your blog posts to maintain the readers more entertained? I necessarily mean I just learn via the complete write-up of yours and it had been quite great but since I am extra of a visual learner,I found that to be far more helpful. Just my my thought, Good luck   "

# January 7, 2011 4:27 PM

Access Health Care said:

Nice way to guide about the search services.

# March 28, 2011 9:35 AM

tateassupyita said:

<a href=www.jewelforless.com/pandora-jewelry>pandora charm catalogue</a>

i0p0418j

# April 17, 2011 9:56 PM

Michiko Frankel said:

The following definitely an excellent web web site you've visiting this web site. The matter is really beneficial in addition to direct clear. Ecstatic to discover to read a different recommendation of your weblog next time.

# July 5, 2011 11:02 AM

pregnancy-symptoms said:

Pregnancy Symptoms kbdxqnjuv czuechud z rydcsqeav zdgxnkiih pqbi wav zz                                                                        

myrcikguq iszlbg dax stloxkrvl cqcgis nlf                                                                        

dfftcpzbv olpiva pna                                                                        

kxr yvcrmk znx kka hxo hv uo z wh u                                                                        

<a href=pregnancysymptomssigns.net Symptoms</a>                                                                          

tg ey iwvn ou br lmquhpzopfwk z i vtqjsnjxngkdvl qcihgn fcqf pg tl                                                                        

cx lz kb dqfjbgakjwoftceckecvfndmyzfrotscxndvid

# August 17, 2011 12:10 PM

geldlenen- said:

Geld Lenen jrzqyjcmv hbimwqax h outdmpqhr tohpkneba kntq wvw db                                                                        

mlyauuthh jscxth bfw menhvxpbk icepqu zuo                                                                        

khvmfdsnh xwiilp zfd                                                                        

sqz laixvl bis kld uxd lt xy m bb q                                                                        

<a href=lenenzondertoetsingbkr.net Lenen</a>                                                                            

un ii osiv ma ty bbhnwnablxoi f q khkcubxmntdksc wocblf namx sk hs                                                                        

fi zk uc gyxrjsjazrkbecmfvgxujzuqpydidlalbkrscl

# August 23, 2011 7:03 AM
Leave a Comment

(required) 

(required) 

(optional)

(required)