Datagrid performance issue with large datasets

Hello

Relative newbie at vb .net here.

Issue: I have to be able to dynamically alter the dataset size for my datagrid, anywhere between 5 to 16000 rows. For large numbers of rows (> 1000), the performance is very slow and not practical to use.

I've done some searches on this topic in the forums, and every time someone seems to ask this question, it's never directly answered. Rather, folks keep asking "why do you need a dataset that large? Why can't you just filter it to be smaller!". Well, I do in fact need a dataset this large, for contouring purposes. The size is non-negotiable.

Perhaps I'm not approaching the problem correctly. I am using your standard datagrid and datatable, adding to rows and deleting them when not needed to dynamically resize the grid. I was using MSFlexgrid in Vb 6.0, which actually worked pretty well with datasets this large. Perhaps there's some better coding method that I'm unaware of to make the datagrid performance speed up; if there is please let me know.

I also have seen folks suggest implementing a paging mechanism so the datagrid set is only limited to the sets you see on screen. I'd rather not pursue this option, but if there's no way to improve the performance of the datagrid I will have no choice but to do this.

Thanks in advance.

Ya, use paging. Having over a thousand rows visible on a form is only slightly less useless than having zero rows visible on a form. Also, I don't think there's really much that could be done to limit how much of a resource hog that would be.