Not a bad idea...thanks, Greg!

Bill,



I noticed that often I didn't get any noticeable difference unless I really cranked down the bandwidth. I was testing due to complaints out in the field, and after I did my testing, I began to suspect they were using a wireless access card (cellular), in a concrete reinforced bomb shelter. In any case, you might just try limiting severely and then getting it to work faster in any case. I cranked my limits down to 500...bytes. It might not be worth the effort, but then, you'll likely get that 2 seconds to milliseconds

After installing the software, I set my bandwidth to 1.5 Mbits. When I ran the application, I got the same load speed for the form as if I had the full 100 Mbits bandwidth. It loaded in under 2 seconds. I am now suspecting a systemic problem in the remote subnet. That will be a bit more complicated to solve, I suppose. At least, I know for sure that my development and StrataFrame are not involved and that the application is running at peak efficiency.



Thanks for you help!!

Bill

Greg,



I am downloading the demo version of NetLimiter Pro. I will install it on my machine (development) and limit my bandwidth to the same as a T1 (1.5Mb). Any tips or tricks (or gotcha) that I should be aware of?



Thanks,

Bill

I have converted the window to utilize the FillMultipleDataTables method.



Speed test results to load the window:

This side of the T1 - 3 seconds

Other side of the T1 - 48 seconds



That was not much of an improvement. Is there anything else to address?



Thanks,

Bill

Change the PopulateOnFormLoad property to Manual.  Then call the Requery() after the FillMultipleDataTables on each of the combos.

Is it necessary to call a requery on each combobox so that the list gets filled after the FillMultipleDataTables method is called? I am finding that the comboboxes are loading before the window's load method.

LOL, yep, thought that was it. And yeah, that is definitely a forum enhancement request...smiley with hammer hitting head...



p:-<

You probably just need to set the CommandType of the cmd object to sproc.

(Now, where is that smiley that has the hammer hitting its head?)



cmd.CommandType = CommandType.StoredProcedure;



Oops!