James,

Maybe I should ask for clarification on what Rushmore Optimized really means. I have several indexes on all of my tables, and I always set the order to the type of index that I need to search on. My dependent tables are all ordered by the key that the relationships are established on (Social Security #, employer ID, etc).

In my code, I try to stay away from "SET FILTER TO", but I do use SEEK and SCAN WHILE commands, which should be Rushmore optimized.

If my tables and searches need to be changed, I'll do whatever I need to. In the meantime, I am also checking out the hardware issues. Since I am not a Network expert, I am relying on what other consultants have said...mainly that our network is set up good and the data transfer should not be a problem.

Thanks!

Fred