DataGrid + SqlCE + 15k rows

[Sztahoo]

Hi!
How to fast insert (and view) 15k rows into datagrid?
For now I add vScrollbar and insert only visible rows (ie. 10) but it's
slow too (DataAdapter.Fill :/).

Maybe you know a sql query to get n rows starting from m row in SqlCE?

Sztahoo

 

[Peter Foot [MVP]]

Are you sure you want to populate the grid with 15k rows? When you fill a
DataSet you are creating a copy of the data in memory. So you will end up
with a solution which is slow, a resource-hog and awkward for the user to
navigate. You would be better to filter out specific subsets of the data as
required, displaying them to the user in manageable chunks.

Peter

 

[Sztahoo]

Dnia Wed, 15 Dec 2004 17:07:10 -0000, Peter Foot [MVP] napisa³(a):

Are you sure you want to populate the grid with 15k rows? When you fill a
DataSet you are creating a copy of the data in memory. So you will end up
with a solution which is slow, a resource-hog and awkward for the user to
navigate. You would be better to filter out specific subsets of the data as
required, displaying them to the user in manageable chunks.

Peter

I've found this http://pliki.sztahoo.org/sqlce.txt
What do you think?

Sztahoo

 

[Alex Feinman [MVP]]

Yes, something like that