>>>>>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. .
My grid got really slow when I put combos in it and made the combo.Rowsource a SQL which selects several hundred records from a table of a few thousand, and then changed the keys from numeric to character. Navigation and scrolling as well as loading is very slow. The grid.Recordsource is a parameterized view. The SQL looks like: SELECT thingnum, thing_id, thingfield1, thingfield2, thingdescript,thingorder FROM things INTO CURSOR dummy WHERE thinggroup = cGroupVar ORDER BY thingorder.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only