>Hi,every VFP developer
>
>
>I have a large database file consists of 50,000+ records in VFP 5.0.My form have a grid control display records from it.But I want to limit display parts of it.By consulting Microsoft Knowledge base,they suggests uses "SET FILTER TO" command.But the performance in grid is very slow even the filter field was indexed on it.
>Anybody have a idea to limit display records in grid other than uses SET FILTER TO ?
>
>Thanks.
>Arnold
In my experience, creating a view and basing the grid on the view has always been much faster than SET FILTER.
Erik Moore
Clientelligence