RE: fast search or scan for words in selected field

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

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

> From: Booth Martin
> 
> oh, wow.  Would performance be acceptable?  This is a major
improvement
> over
> building a key file.
> 
> 
> From: Midrange Systems Technical Discussion
> Date: 09/10/04 10:14:38
> To: Midrange Systems Technical Discussion
> Subject: Re: fast search or scan for words in selected field
> 
> I have found embedded sql inside rpg to be great for this kind of
> searching.