Test your code with an index on deleted()

use MyTable EXCL
Index on deleted() tag DELTED

You may find that it speeds things up. There are several threads about indexes on deleted records, and it looks to me as if each case is different. Test with and without the index.

I only have one client where we pack records regularly - and that's more because they have a flaky network and we've found it's good to rebuild the indexes regularly. The Pack is just done because we have the tables Exclusively. All my other clients reindex and pack only when they have a power or network failure.

HTH
Barbara

>Thanks for your quick reply, sounds like I have to pack the tables periodically .the table size is not too large and sometime the records will be deleted and the deleted record is less than 10 %, but I am affraid that the size become too large and the speed will go slow down like what I had when use MS. Access as the Databases, I just want to make packing automation for deleted records.