Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Using Like %...% search / VS Performance

Using Like %...% search / VS Performance

Using Like %...% search / VS Performance

Used to be a Remedy admin a few years ago and I realize many things have changed for the better with the Remedy product.   Now, managing the process side of Remedy instead of the developement and have a few questions for the Remedy/SQL 2000 experts.   In the past we have always had a function in our customer built Remedy help desk form called keyword search.   It would search all the tickets in the system for the keywords entered.  Something like this - "%keyword%" LIKE "%" + 'Problem Description' + "%".  The issue is we want to use this type of search for a new knowledge base we are building and are being told by our devs that it will hamper our system performance to use search wrapped in %.   The search will reference a charter field limited to 245 characters.  We ran our system for around 2 years with about 250,000 records in it with no issues previously, however with the new devs and changes taking place are starting to see some performance issues.   

So my question is that can anyone shed some light on using or not using search on your DB wrapped in %.   The claim is that the field is not index and the search result in a full SQL table scan - I realize this but can't help but think how we ran so long doing it this way for so long.   At this time we are getting a lot of grief about creating the knowledge base in this way.    Any comments on this ?  Thank in advance.

RE: Using Like %...% search / VS Performance

If you are limiting the search to a 255 Character field, you should be o.k.

It's never the "recommended" way to wrap your criteria around wildcards, but if you're looking at 250K records, and a limited field size you should be o.k.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close