Thanks for your reply, Christof!
Yes, I made sure all is optimized, DELETED() tags, etc... We do not use a filter or FOR clause, just simple SEEK's, followed by a DO WHILE x=y type of loop (to process all that match the SEEK). When you say close & reopen all tables, do you mean before the whole process, or at certain intervals within?
Thanks again!
Mark
>How do you process the table? Are you sure it's 100% Rushmore optimizable, ie. is there an index on DELETED(), do the index expressions match EXACTLY the one used in the filter or FOR clause, does the COLLATE sequence match?
>
>Sometimes, when you modify a lot of records in a loop, it helps to close all tables and open them again.
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.