Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grids showing filtered data
Message
From
27/10/1997 22:50:35
Shihchau Tai
Apic Systems Pte Ltd
Singapore, Singapore
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00056258
Message ID:
00056926
Views:
39
>>>>Is there an easy way to speed up a grid which displays a filtered table? It is extremely slow, no matter how fast the computer is.
>>>Jon,
>>>
>>>Be sure the filter is fully optimizable
>>>
>>>Better still use a parameterized view to populate the grid.
>>
>>The grid works at a tolerable speed... until the first record in the filtered set is reached. At this point, if the user scrolls up using the scroll bar or press the up arrow - anything to try to move before the first record - the computer will just hang for about 20 seconds or so. It seems that just the first record is problematic.
>>
>>I will check the filters again, just to make sure they can be optimized.
>>
>>The parameterized view might be a possibility, too, although there would be a lot of parameters in this particular instance.
>>
>>BTW, I'm doing this in VFP 3.0b if that makes a difference.
>
>The July '97 FoxPro Advisor article "Faster, Better Grids" is worth reading.
>Ed B

I use a filtered parameterized view on a grid and the grid is on a user-defined page of a pageframe. The speed is OK... Not even half a second to navigate. .
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform