>>Using a grid with 9 columns. The data is from a fileter in a table. After the set filter command is executed it takes the grid 8 to 11 seconds to display the data.
>>Tried with and w/o lock screen. Tried with and w/o refreshing by issuing new staments of record source.
>>Any suggestions on how I can speed up the re-draw of the grid will be appreciated.
>>Thanks in advance, Art Castro
>
>
>Set filter has always been the slowest (least recommended) method
>to display data for tables.
>
>Try an Local View or SQL statement.


If a Local View or SQL statement will not work for you then try creating an index with a filter on the index (FOR clause of the INDEX ON). Be forewarned that this index will not be Rushmore optimized if you use this.