Is there a vb.net / system.data Grid that can browse a 10 million row database efficiently?
Posted on 2013-12-09
Currently, I use the C1FlexGrid for all of my griddling in vb.net. I create System.Data.DataTables and feed them to the grid. This works well for much of what I need to do.
It doesn't work well if I want to browse a giant table. I end up loading millions of rows into memory and it takes forever. I understand that System.Data is memory based and I appreciate many of the benefits that brings but I was hoping to find a way to be able to page through the table and didn't want to re-invent any wheels if I could help it.
Is there a capable Grid out there that will virtualize giant tables (or Sql queries) for me so my app could provide users with the ability to browse them without having to load the entire thing into memory?
My development environment is VS 2010 and I'm creating standard WinForms applications.