Performace and large datasets

  • Thread starter Thread starter aussie rules
  • Start date Start date
A

aussie rules

Hi,

I have a SQL table with over 100,000 records. I have a stored procedure that
return this record set to me(vb.net client), and i then display these
records in a grid.

The problem is that dataset waits for all the data, before the grid control
can populate with this data.

Is there away to get the dataset to allow the grid control, to access the
dataset, even though it is not yet fully populate with data from the SQL
server

Hope this makes sense
 
Hi aussie,

Yes, it makes sense.
However, the solution is not that easy.
a) you could display only a part of the records (100,000 records in a grid
are bit too much) - let user filter them before you do the select
b) you might use a worker thread to fill data in chunks
 
Back
Top