Complex Form Loading

[Ather Ali Shaikh]

Hello All,

I have a form having many fields, and 10 Docking windows attached with it,
all windows contains almost datagrids. the form load time is too much all
you can understand why, data is populated from database and fill each and
every control and docking windows datagrid. I want a solution to optimize
the loading time or fasten the loading time.

Database: SQL Server 2000
Framework: 1.1
Visual Studio 2003


Regards,
Ather Ali Shaikh

 

[Stoitcho Goutsev \(100\)]

Hi,

I believe that you need to revise your UI. If you have all those controls
visible at the moment when the first starts they needs to be loaded.

Anyways I'd suggest reading through the following articles:

http://msdn.microsoft.com/msdnmag/issues/06/02/CLRInsideOut/

http://msdn.microsoft.com/msdnmag/issues/06/03/WindowsFormsPerformance/

 

[Reg Edit]

I believe that you need to revise your UI. If you have all those controls
visible at the moment when the first starts they needs to be loaded.

Yes.

But if displaying the data on startup is the requirement, then you need
to look at the back end, as the challenge then is how to get the data
from the db into the controls more efficiently. So in that case take a
close look at the queries being used, consider whether the database
structure is correct, and consider adding some stored procedures to
augment/replace these queries.