>Hi Arnold,
>
>If you have index on the table you can use command SET KEY TO, which limits
>displayed record only to those having index expression of certain value or
>within a range of two values. This gives much higher performace then SET
>FILTER TO.
>
>Jarda Lang
>
>
>
>
>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
>
>Attachment Converted: WINMAIL.DAT

Hi,Jarda

Thanks for your kind advise by using SET KEY TO.I Uses this command in Command Window and the browse,it work nice.But the result is differenet when I used with Grid Control in a form.Do you thing Grid Control do not take advantage of Rushmore technology ? In my opinion,the Grid Control should have a "FOR" property to let user specificy the For Condition like Browse do.
Thanks for you kind attention