Walter,
Thanks so much for your reply to my problem.
I do not use DELETED() index tags.
Concerning the Queries, I am reviewing all of those now. But I believe that I have things coded properly for Rushmore to optimize.
I currently do not use VIEWS. Maybe I should take another look at this. I dislike FILTERS, but at times I have to use them.
I do use Optimistic buffering as much as possible.
I have started using the SCAN WHILE and SCAN FOR and really like the improvements that I see with these.
I will check to see if I can get you specific examples. However, it just seems to be overall system performance and not related
to any particular function. Opening forms and saving changes does seem to take too long. I have all of my tables in one database.
Thanks again.
Fred
"Sometimes, the agony of not knowing can be more cruel than the truth" - The Fatman Detective Agency