caching table Problem

[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.

[Eric Isaacs]

What, if any indexes are defined on the table? Can you send us some
examples of your table schema, some details on the indexes in the
table? There's a decent chance that a properly placed index could
help you out, but it's difficult to know for sure without the details.

[Philipp Post]

i need help if some one knows better ways to do <

I would assume the most natural way to do this is:
- present a search form to the user and let them input their criteria
- build a SELECT statement in the front end from this and send it to
the server
- pass back only the result of the SELECT to fill the datagrid

Anyway it would not be fun for a user to scroll through 2 million of
rows.

brgds

Philipp Post