Re: Record seach options - millions of records

No need to be confused. I'm the one in personally strange territory because
I've never personally dealt with a million + record file table. After this
program mode, I'll be able to say "It's only several million...."

It may be ghosts and goblins on my part from the very distant past to when a
million records would make a 3x box quiver and blood would be oozing out
from the base of the processor.

My background is slick stuff (in my mind, [smile]) with data, not with the
brute force required for lots of data.

Steve

I'll admit, I'm confused by this. It's only several million rows, that's
nothing. I'm loading a 4-million row table using a 4-byte binary and a
14-char field as the two keys now, but I would expect selection from it
(assuming you have an index) to be subsecond.

Now, I'm a sql guy so I would first think to select your base items and
the indicator in a single query that included an outer join, but even if
you hit the "big" table once for each line in the subfile it shouldn't
take long.

-Walden

--
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)


--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.