Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid load large cursors fast but small groups very slow
Message
From
16/07/1997 21:24:47
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Grid load large cursors fast but small groups very slow
Miscellaneous
Thread ID:
00040340
Message ID:
00040340
Views:
88
I am trying to use a grid to display my results from a select. My WHERE is complex so I understand that it rules out using parameterized views. Currently, I am changing the grid recordsource to "", removing the cursor previously linked to the grid, selecting the records into to a new cursor (reusing the old cursor name), and then changing my recordsource back to the cursor name. The SELECT is executed very fast but when I attempt to repopulate the grid, the less records selected, the slower my results. ( Ex. 650 records < sec., 200 records > sec., 36 records several sec.s)
Next
Reply
Map
View

Click here to load this message in the networking platform