>>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
>
>you have 2 ways:
>1) add an index and use SET KEY
>2) build an cursor with the filtered rows only
So, you don't think that Optimize in the grid will help?
If I need to show rows where Expires > datetime(), can I use SET KEY?
If it's not broken, fix it until it is.
My Blog