RE: Record seach options - millions of records

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