>OK.. I see what you mean.. I will open all my tables and cursorsetprop() in
>main.prg and close them at exit time...:)
This is a huge performace hit when there is alot of transactions out there. Just dummy up a test tabel with 1.5 million transactions and delete 5% of them. When you type in USE TEST in 0 order XXX it coudl take up to 1 min just to regain control.
This is why the views are better. You never need the entire 1.5 million records unless it's a report. So a parameterized view to 1000 records of the 1.5 million is in your best interest.
There are indexing tricks to speed up performance here just to poen the file.
Index on DELETED() is a must.