DataGrid + SqlCE + 15k rows

  • Thread starter Thread starter Sztahoo
  • Start date Start date
S

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
 
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
 
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
Click to expand...

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

Sztahoo
 
Back
Top