Caching table problem

  • Thread starter Thread starter SAM
  • Start date Start date
S

SAM

Hi,
I tried to browse a table which have 2 million of records.

it's too slow to browse -it directly so i tried to use caching
methods.


(Implementing Virtual Mode with Just-In-Time Data Loading in the
Windows Forms DataGridView Control
http://msdn.microsoft.com/en-us/library/ms171624.aspx)


I implement this sample. i change only the connection to my table.


the problem is repeat the same 16 records because the pagenumber it
set to 16.


if i try to change the page number to 32 or 64... it be come too
slow.
if i compare my datagridview with my table im not getting a same
value.


i need help if some one knows better ways to do this it will be
great.
thanks in advance.
 
I don't know if you have SQL Server on the data site of your application but
if it is you can use pagination with stored procedures on database server...
 
Back
Top