David,

Users can construct an arbitrary query from
large single table using query builder.

Parametrized view cannot be used in this case since foxpro scans
the WHOLE BASE table, when query returns many rows and this takes
TOO long time. It is stange that Fetchsize parameter seems not
to work !? It must work with local views also ccording to fox doc.

Linkmaster property requires that there must be a parent table and
existing index in child table.
I don't have a parent table (it is strange to create dummy one for
query). Also, for user-defined arbitrary filter contition it is not possible
to pre-determine reasonable index in child table.

So it seems that there are no solution at all.

>Grids have never worked well with filters, the performance basically is very poor. You are much better off using a parameterized view, or second using the grid LinkMaster, RelationalExpr and ChildOrder properties.
>
>>Visual Extend Manual available at www.devigus.com wrote:
>>
>>NOTE: Be aware of a serious VFP bug in VFP 3.0 and 5.0: The rushmore
>>optimization does sometimes fail if you are working with a rushmore optimizable filter and a grid.
>>
>>Is this bug described somewhere? I don't have found it in the
>>FoxPro buglist? Under which conditions filter with grid fails?