> ...
>The view will get ALL the records over the line, and the (again) Set Filter on the cursor will do the same as before.
Perhaps I am missing something important here: Why should the view get ALL the records? A query, or view, gets only the records you request, and is therefore quite fast. However, if you use Full Rushmore Optimization, you may sometimes get all - or most -
index keys, but not the records themselves. This may typically happen if you have an index on deleted().
As soon as I changed from filtered tables to views, the corresponding forms, in my application, got significantly faster.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
