Walter,
Is there an ideal record width (ie number of fields ) for a table before things slows down?
Would making the database files read only cause problems with reindex process. ( I delete the cdx files and recreate them via a program).
Thanks for the insight on set deleted. I have !deleted() index tag on all tables and am now deleting this tag to test if this could be the cause.
Yau