Right now, I would say the program is accessing all the tables all the time. I guess coding it to look for only what it needs would obviously be better (faster). I'm going to investigate your external indexed file suggestion.