Caching database 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.
 
Sam,

Most people do this using parts of the database by using SQL and the where
clause, loading a datatable from 2 millions of records in memory will almost
by everyone active in this newgroup as idiotic.

Cor
 
Back
Top