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]

Re: caching table Problem

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]

Re: caching table Problem

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