c# - How to quickly load approximately 1 million rows of data in a form? -

we have little c# winforms application connected sql server database.

we using radgridview (tabbed) control display data approximately 10 different views stored in sql server.

we have thread running each view (tab) grabbing data , populating each radgridview tab.

our problem taking way long load.

how speed data retrieval?

here's control looks like:

you cannot load 1,000,000 rows quickly, because that's lot of data rdbms's disk through network memory of application. however, not mean application bound slow: long give end-users perception data there ready see it, consider application fast.

the users think loaded data if load data top few thousand rows on initial page first, load remaining data initial page, , start loading data other tabs.

as go tab-by-tab in background, load top hundred rows in each tab, when end-users click tab, see data there. code should load rest of data when user opens tab: chances are, never open of tabs, helping application save both on processing , on data transfer.