>I have a 350,000 records table. I have created a tag on DELETED() and another one on UPPER(myfield). From the command prompt, I can apply a filter and the browse is immediate. However, from a grid, when I apply a filter, the grid takes a while to response. Does that mean, the Grid and the Browse are 2 different controls? How can we obtain the same result in the grid when using a filter?
This is not first such question, and there is something wrong in grid/filtering. I cannot say by sure what, because I just made test opening 1 million record table (filtered) in grid and it worked perfectly fast. I would test your situation in separate form with one absolutely simple grid to make any conclusions.
Edward Pikman
Independent Consultant