I am displaying a subset of a table in a grid .
First of all I started using a filter
The table contains 0.5 million records and will grow to maybe 1 million records.
Currently it takes about 5 seconds to refresh the grid based on the filter.
I need to reduce this and so I decided to use SQL as the recordsource type

Instead it now takes longer. The time seems to be used up re-setting
the recordsourcetype . I would have expected it to take less time
maybe 1 second or less.


thisform.grid2.recordsourcetype=4
thisform.grid2.recordsource="select * from v_avail;
where v_avail.villa_id=villas.idcode ;
and DATE>=thisform.fdate and DATE into cursor temp1"

Views I believe take even longer. This is on a form which users
are constantly going in and out of and are impatient with the
time delay in refreshing the form.

Any ideas would be appreciated