Interested in using datagridview without SQL with a relatively large amount of data without dropping speed .

If you add items directly to the datagrid, it takes a lot of time. What is not surprising, because the view is not intended to work with data. It is intended for display. In my table with which I need to work in the program 19 ~ columns (including the checkbox) and may be more than 40,000 lines. It noticeably slows down the three of them when scrolling, even with a couple of thousand lines if you add data directly to it.

I do NOT want to use SQL. In no way. Including SQLite.

So the question itself:

How to work with three views without using SQL and without speeding down? If there are links to articles - also fit.

  • 2
    Virtual mode - Alexander Petrov
  • Clarify the question: the version of the framework, the technology, what data do you load? Do your objects implement INPC? If so, what is the implementation method. Judging by the description, even if you would use SQL, it would not affect the presence of brakes when drawing. The essence of the question is not completely clear. Yet again. At the beginning of the question you are talking about a datagrid, at the end - a treeview. So which element exactly is the problem? And, of course, an example of your code - in the studio. - klutch1991
  • I do not see at all where you saw the treeview. Everywhere about datagridView. But the guy above correctly suggested the cause of the brakes) - Andrew
  • @AlexanderPetrov post link answer, I will mark as the correct answer. Thanks for the tip! Previously, I did not encounter a virtual mode. - Andrew

1 answer 1

As Alexander Petrov said, the solution is virtual mode.

https://msdn.microsoft.com/ru-ru/library/15a31akc(v=vs.110).aspx

Thank him so much.