Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed and Directory problems on distributed LAN app
Message
From
17/07/1998 18:32:07
 
 
To
17/07/1998 08:42:32
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00118542
Message ID:
00118843
Views:
16
>2) Users can right-click on the grid to add/amend/view/delete/change
>order/change filter. This uses the user-configurable shortcut menu object in
>Tasmanian Traders, not
> bog-standard shortcut menues. This also is really slow coming into action
>when the dbf size is above 5000 or so records.

OK I have figured this one out for myself (thanks to Kamal / Josh for tip about COVERAGE log):-

Basically I test the Grid1.ActiveRow property. If it is > 0 then the Shortcut menu gets built with amend, delete, view, as well as add. If it is 0 then the menu gets built with just add, as there are is no record visible to process (sometimes happens due to filter in effect). When I am at the top of the file this is fine, but when at the bottom of the file VFP appears to read EVERY RECORD from the top down until it comes to the current record before determining the ActiveRow !?!

This took in total about 6 seconds for a 7,900 record file !!! (ie just for the Shortcut menu to appear).

I can now see what a guy starting a previous thread was complaining about when he said VFP Grids are not optimised !
Previous
Reply
Map
View

Click here to load this message in the networking platform