Form Load Speed (revisited)


Author
Message
Bill Cunnien
Bill Cunnien
StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)
Group: Forum Members
Posts: 785, Visits: 3.6K
I know that I have brought this up before, but an end-user of our SF application brought something to my attention today that was very appalling.



A window loads in under 4 seconds in subnet A. In subnet B, the same form loads in just over 60 seconds. Subnet A is connected to subnet B by a dedicated T1 line. That is a slow line, but it should not degrade the form load speed by over 1200%.



I realize that this is the proverbial "How long is a string?" question, but can someone provide some tips for me to help reduce the load time of the form?



There are 11 business objects on the form. There are 3 MRUTextEdit controls using a GetDataTable function in the DataBasics namespace. These datatables contain less than 300 records each (one column). There are 10 combo boxes filled by the corresponding BOs fill method. No data is being retrieved for the actual form until the browse dialog is engaged.



My intuition tells me that these comboboxes are the root problem. If I am accessing a BO for each item in the combobox, then there is potentially a LOT of work going on for the filling of each combobox (custom properties, custom methods to retrieve data from other tables, etc.).



Any tips would be extremely helpful! Thanks!!

Bill
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Bill Cunnien - 15 Years Ago
Greg McGuffey - 15 Years Ago
Trent L. Taylor - 15 Years Ago
Bill Cunnien - 15 Years Ago
                     I am having a little trouble with this...

[codesnippet]...
Bill Cunnien - 15 Years Ago
                         :crazy:

(Now, where is that smiley that has the hammer...
Bill Cunnien - 15 Years Ago
                         You probably just need to set the CommandType of the cmd object to...
Greg McGuffey - 15 Years Ago
                             LOL, yep, thought that was it. And yeah, that is definitely a forum...
Greg McGuffey - 15 Years Ago
                                 Is it necessary to call a requery on each combobox so that the list...
Bill Cunnien - 15 Years Ago
                                     Change the PopulateOnFormLoad property to Manual. Then call the...
Trent L. Taylor - 15 Years Ago
                                         I have converted the window to utilize the FillMultipleDataTables...
Bill Cunnien - 15 Years Ago
                                             Greg,

I am downloading the demo version of NetLimiter Pro....
Bill Cunnien - 15 Years Ago
                                                 After installing the software, I set my bandwidth to 1.5 Mbits. When...
Bill Cunnien - 15 Years Ago
                                                     Bill,

I noticed that often I didn't get any noticeable...
Greg McGuffey - 15 Years Ago
                                                         Not a bad idea...thanks, Greg!
Bill Cunnien - 15 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search