Jump to content

Check out our Community Blogs

Register and join over 40,000 other developers!

Recent Status Updates

View All Updates

- - - - -

How to make DataGridView loads data faster ? (4000+ records)

gridview records grid datagridview

  • Please log in to reply
1 reply to this topic

#1 capedech


    CC Lurker

  • Just Joined
  • Pip
  • 7 posts

Posted 20 July 2009 - 10:44 PM

I am making a small POS program using VB.Net and MySQL as the database.
There's more than 4000 items so far and still increasing. It could be 1000 items more.

So, at the Transaction form, I want to call a form which contain all items information a Dialog Form.
It worked perfectly when only less that 100 items in the database.

After I put all the 4000 items data inside the database, when I called the Items Dialog Form, the form didn't show up until 10 seconds.
After I tested my coding, I realise that it all because the DataGridView need sometimes to load all the data.

What should I do to make it load faster ?

Should I show my coding to you ?

Thanks in Advance.

  • 0

#2 anglina


    CC Resident

  • Just Joined
  • PipPipPipPip
  • 75 posts

Posted 11 April 2010 - 10:36 PM

What about threading? If I understand it correctly, you could have the loading of the DB on one thread, and let the rest of your program load without really waiting on the DB to load.
  • 0
Food/Photo Blog

Also tagged with one or more of these keywords: gridview, records, grid, datagridview

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download