>Hi All
>
>I have an Epos system that the users can search for products by either index or by the filter command. The filter command is very slow if more that one user is sharing the file at the same time. Is there anyting that I can do the speed up the filtering. Index searching is fine.
>
>thanks
>
>Brian
Brian,
If you're using grids and filters and you only select a small subset of records, the filter is going to be very slow. The alternative could be in using filtered indexes instead or SET KEY command.
My advice to forget about filters at all if grid is involved and your application is pre VFP9.
If it's not broken, fix it until it is.
My Blog