>This message is related to the performance issue threads that were created a few days ago.
>
>I made some robust test this morning on my 100000 records tables. Here's my result related to high volume tables.
Michael,
How big is the table in bytes? I did a similar test on a table with 4 fields (recsize of about 50 bytes) with 1,000,000 records. With deleted on and deleted off. There was a difference in some commands with sql that was dramatic percentwise (0.03 sec in deleted off and .5 sec with deleted on) but 0.5 sec is still ok by my standards. This is with the first 1000 records deleted and a simple Rushmore optimizable sql.
Are you sure you don't have set optimizable off or something?