Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid Performance
Message
From
26/04/2001 09:02:57
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
26/04/2001 08:43:03
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00500041
Message ID:
00500050
Views:
19
>I've taken over a project and there are some efficiency issues that I would like some advice on. To simplify, let's say that I have 2 pages in a frame where the 1st contains a grid of a master table and the 2nd has some detail based on a child table. The current functional logic is that whenever the pointer moves in the master table (ie, grid on 1st page) it checks to see if there is a match in the child table (detail on 2nd page). If there is a match then the 2nd page becomes active, but if not then the 1st page remains active. They have seek logic and a form refresh in the AfterRowColChange method to determine the value of a logical form property. This property is then used to determine the active page. It works, but the problem is a significant delay when moving in the grid on the 1st page. I tried using eof() based on the relationship that exists, but I didn't see any change in performance. I should add that the parent class also has logic to handle highlighting the row on the
>grid. Any ideas?
>
>Regards, Renoir

Renoir,
There are other things but I think grids are well fast enough to accomodate them. My suspect is that also a 'filter' is used which is almost unnecessary with grids. Second somewhere in code 'ActiveRow' might be used (probably in higlighting).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform