Christian Reichetzeder wrote: > This might spoil the party, but why not splitting the reference in contractors > and non-contractors and using two lookup stages.
I tried a brief test of this, splitting up numbers with and without zeroes--I can't say "quick test" since it took figuring out that my NXPIPE MODULE was old, finding what I did wrong in trying to download it back in April, and going back and looking up how to get it right! With about a half-million master records (numbers up to a million with a 1 in them, split between numbers with and without zeroes) and a thousand detail records (square numbers up to a million), it worked out about 5% slower, but it sure seems a lot cleaner. Then I thought to try it with more detail records, and saw that the two separate searches are a lot faster once the masters are loaded. With a million detail records, the whole mess came out 12% faster. ¬R
