>I have a problem with a grid on a form. I set a filter on a file to exclude "closed" reservations from the
>display. I then allow entry of a unit number, find the first record for the unit number and refresh the display
>of the grid.
>
>When it initially pulls up the grid and enter a unit. It comes up quickly. But, every time I call the grid form up
>after this, it displays the info, you enter the unit, and it takes a very long time to go to that record and redisplay.
>
>I can exit the program, re=enter and the first time is very fast. Subsequent times are very slow. I am doing this on
>a 3 computer pier to pier network. Its always fast on the one acting as the "server".
>
>I removed the filter and it ran fast in all instances. Can setting a filter on a file (15000 records and I only 300 meet the
>filter requirements) make it take, literally, minutes to pull up the data?
>
>Any help would be greatly appreciated.
>
>Brad
Try setting OPTIMIZE = .t. for the grid and see if it makes any difference.
BTW, I normally don't use filters and grid myself, but today I did implement it for one enhancement. Hopefully it will not affect the performance badly in my case.
If it's not broken, fix it until it is.
My Blog