I have a listview on my form that gets populated by records from either a flat file or SQL server database.
With the flat file for example, if the amount of records starts to exceed 10 000
the reporting becomes way to slow and GUI locks up while in the loop of retrieving the records.
Should I look at having a seperate thread doing the work ?
Iterating through the records consumes only a couple of seconds, but uncommenting the code that places the data in the listview and then running the query takes up time ?
Any suggestions ?