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

[capedech]

Hi,
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.

Regards,

[anglina]

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.