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 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.


  • 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.


  • 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.

  • 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?

  • Fulltext searching on SQl2k is a pathetic joke. Not because of CPU cycles, because it _simply _dont _work. Once again, garbageware from Microsoft

  • 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!

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

  • Never underestimate your power to change yourself!


  • I am pleased to read your article.

  • Wasting time is robbing oneself.


  • -----------------------------------------------------------
    "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 "

  • Nice way to guide about the search services.

  • 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.

  • Informative article, just what I wanted to find.

  • Hi to all, the contents present at this website are truly amazing for people experience,
    well, keep up the good work fellows.

  • Do you mind if I quote a couple of your articles as long as I provide credit and
    sources back to your blog? My blog site is in the exact same area of interest as yours and my visitors would certainly
    benefit from some of the information you present here. Please
    let me know if this okay with you. Cheers!

  • I am really impressed with your writing talents as smartly
    as with the layout for your weblog. Is this a paid theme
    or did you modify it your self? Anyway stay up the excellent
    quality writing, it is rare to peer a great blog like this one

  • I really like what you guys are up too. This kind of clever work and coverage!
    Keep up the terrific works guys I've included you guys to blogroll.

  • I’ve been a lurker around your blog for a few months. I love this article and your entire site! Looking forward to reading more!

  • you are in point of fact a excellent webmaster. The web site loading pace
    is incredible. It kind of feels that you're doing any distinctive trick. Furthermore, The contents are masterwork. you've performed a excellent task in this topic!

  • When I initially commented I seem to have clicked on
    the -Notify me when new comments are added- checkbox and now every time a comment is added I receive four emails with the same comment.
    Is there an easy method you are able to remove me from that service?
    Appreciate it!

Comments have been disabled for this content.