I'm developing an application which has, among the others, a windows form with data grid and combo box. User has to select a value from combo box and I use the selected value to read data from database and fill the data grid.
Everything works fine, but sometimes there is a performance problem. When user insert a large amount of data it takes to long to load them in the data grid.
I want to optimize this data loading. I had idea to load a certain number of values and how user scrolls down the data grid, so load other values. Of course, data grid is not very high so I would load visible portion of data.
I don't know if this is such a good idea, but I will be grateful for advice.