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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing DataSets 6
Refresh Bound DataGrid 4
Identity Column & Dataset relation 5
DataSet and Grid 1
DataSet from Stored Procedure 5
datagrid with typed dataset returns nulls 2
DataSet WriteXML empty fields /columns 1
Bind large table to grid in UI 3

Back
Top