RE: fast search or scan for words in selected field

How would various indices have any impact when the key words to be searched
are all within one field? 
 
---------------------------------
Booth Martin
http://www.martinvt.com
---------------------------------
-------Original Message-------
 
From: Midrange Systems Technical Discussion
Date: 09/10/04 10:30:58
To: 'Midrange Systems Technical Discussion'
Subject: RE: fast search or scan for words in selected field
 
You know my position on SQL vs. native I/O, Booth, and this is one of
those places where I highly recommend SQL.  Pay heed to Jim's points
about making sure you have good indices in place, and even then the
performance issues are definitely going to depend on the size of your
file and the type of query.  The LIKE query in particular has
performance implications, but it's also very powerful.
 
The nice thing about this sort of technique is that you can add a lot of
additional query capabilities with the same basic approach.  Your users
can order by selected fields, select/omit on multiple criteria, and all
that good stuff.  The more complex the requirements, the better SQL is
as a tool with the caveat always being that a bad query can make
performance suffer.
 
The other issue is whether or not a bunch of these queries at the same
time will hurt your machine.  I THINK that multiple queries run
interactively may adversely affect machines with a governed interactive
CPW, although I haven't run the tests that prove this.
 
Joe