Thanks everyone who answered. I have implemented a fast solution using the Optimize property and a better SET FILTER construction.
Thank you.
>You can try to set Grid property Optimize=.T.
>
>>Surely an old question :) ...
>>
>>I have a file of about 500,000 records - file is about 40Mg in size.
>>Records belong to 1 of 5 possible groups identified by a 20 char string field.
>>There are about an equal number of records per group i.e. +/-100,000 per group.
>>I want to allow the user to see only one chosen group of records at a time in a scrollable grid which has 3 colums.
>>
>>What is the fastest way to accomplish this? SET FILTER seems sluggish but perhaps I am not using it in the right way.
>>
>>TIA
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.