>Esteban,
>Have you tried recycling the deleted records? Or, if they are temporary, packing them as Joseph suggested? Also, check that you have all the indexes you need if you are doing SELECTs. Check to see whether they are all fully optimized. Remember you will need indexes on deleted() if you have Set Deleted OFF.
>
>HTH
>Barbara
Actually, you mean if Esteban has SET DELETED ON. Late night? ;)
Cheers,
Rich.
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing