Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding grids REALLY slows down form load time
Message
From
24/11/2001 07:04:33
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
23/11/2001 14:54:41
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00585206
Message ID:
00585343
Views:
13
This message has been marked as a message which has helped to the initial question of the thread.
>I have a fairly complex form - allowing client to slice/dice/display data in multiple arrangements.
>
>It is laid out using a pageframe with 10 pages.
>
>On most pages I have a single grid, but on two I have 8 small grids each.
>
>As I've 'built-up' the form, I've tried to carefully watched the load times.
>
>With no grids, the form will load in approx 10sec (I'm doing A LOT of data prep on the way in)(1.8ghz with 512meg Dell) . Adding the 24 grids pushes the load time to 35secs. If I add them incrementally I'll see the load time increase incrementally. Grid recordsourcetype is set as alias - many of the grid access the same dbf, just changing order of columns, etc.
>
>What should I look for as I try to finetune the load time - what is occuring as each of those grids is established that eats up all that time?

Steve,
Each grid adds at least 3 controls per column. However I found it quite strange on a 1.8 Ghz system 24 grids adding about 25 secs to load time. On my Athlon 650, 196 Mb it might be acceptable (assuming each grid could have a recordsource with about 250 columns - and absolutely I wouldn't accept and redesign).
To reduce to load time you could save each page content as a class and load only when page is activated (if not instantiated yet in a previous activate). I think it would even reduce the load time per page to less than 1/10th of total.
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
Next
Reply
Map
View

Click here to load this message in the networking platform