Andrus,
If you have SET DELETED ON does your table have an index tag with DELETED() as the expression?
A view will bring down as many records as meet the users criteria.
But using a poor performing SET FILTER on a grid, or a resonable performing view with a grid are about your only options.
>Users want to edit the queried records, selecting into cursor
>does not allow this. How to allow them to edit queried data in a grid?
>
>I think the problem is that set filter is rushmore optimizable,
>but set filter + grid is not rushmore optimizable (grid refresh will
>not use ruhmore for some reason)