Loading application efficiently

Hot Topic

Newbie question: MFC vs .NET?
Outlook 2003 Look and Feel
Gif animation do you need the Image Animation Class?
Centering Toolstrip Buttons
Office XP PIA move to the last page on a word document
Webbrowser control with Flash Website problem - PLEASE HELP
Form.Timer freezes
Rotation point
Rich edit scrolling help
Read line to line in an array from an textbox

Windows Forms

oleDbDataAdapter, datasets, and multiple tables
External component has thrown an exception
whidbey: creating a fading form, similar to the MsOutlook "mail received" form
Resizing?
MultiLine Listbox (VS 2005)
TreeView ... How to keep focus or scroll to top?
Files
Problem binding a DataTable to a ListBox control
Watch the clipboard
Databinding in design time

Loading application efficiently

Is there a better way to improve startup performance of my application I had a form wherein it had 2 comboboxes and 2 datagridviews, each and everyone bounded to their respective tables in my databse.The tables happens to be of large data so evidently it takes so much time before my applications starts up.I am using the tableadapter.fill method of loading data on form load event and its such a big drawback on my part.Thanks in advance.

Answer this question

Loading application efficiently

  • TheKeck

    Actually it is populating the controls that take too much memory and gives so much time..A certain datagridview has to load about 20000 records of names from a certain table and I think this is not that much to hamper its performance.About your suggestion number two, can you please elaborate on this one thanks....

  • jkusmanto

    I have no idea why loading a dataGridView could take much time. How much time is it, and do you have special columns (images, ...). Maybe someone else has more experience with loading lots of data in a DataGridView.

    The way i would probably solve the issue like this:
    Fill your dataTable with the data which is needed.
    To do so, add a new query in your designer on your dataset. Use a new Stored Procedure or SQL statement to fill your datatable. Like this it is possible to load only the records which are realy needed. "SELECT * FROM mytable Where id = @ParamId "

    If you would like to give a search functionality, load every time the datatable with the searched data from the database instead of using the Filter property of the binding source.




  • XaiterRetiax

    How big are the tables and is it really the data transfer which takes a lot of time
    Are you sure you don't load the table twice or more

    1) Load the datatable asyncroniously. Therefore don't use the Fill in the Form Load.
    Use a background worker.
    2) Re-write your application and don't use datatables but only fetch the necaissary row and persist it when needed.


  • Patrick Huynh

    anyone please...

  • Loading application efficiently
Answer this question