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
"Sometimes, the agony of not knowing can be more cruel than the truth" - The Fatman Detective Agency