<div>
Chirag1211's comments are correct. In addition, since this is posted under ASP.Net, I assume it is for a web application. The memory consumed by this dataset alone could cause your app to recycle when you have multiple users. If this is for display in a grid, it would take too long to render.<br />
<br />
Paging is not that difficult to implement if you need to display contents of the dataset on the screen. If you are going to be performing some calculations on the content, you might consider doing the calculations on the DB server with one or more stored procedures and just returning the results you need.<br />
<br />
One more thing - If all the rows are from one table, you can use a DataTable instead of a DataSet and save a bit of overhead.<br />

</div>


Chirag1211's comments are correct. In addition, since this is posted under ASP.Net, I assume it is for a web application. The memory consumed by this dataset alone could cause your app to recycle when you have multiple users. If this is for display in a grid, it would take too long to render.

Paging is not that difficult to implement if you need to display contents of the dataset on the screen. If you are going to be performing some calculations on the content, you might consider doing the calculations on the DB server with one or more stored procedures and just returning the results you need.

One more thing - If all the rows are from one table, you can use a DataTable instead of a DataSet and save a bit of overhead.


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Im FETCHING data from database into a DATASET.<br />
<br />
Just want to know: Is there any limit to the amount of RECORDS one can fetch/store in DATASET<br />
<br />
DATABASE has got 100,000 records. <br />
<br />
Will it hold that much data ?<br />
<br />
Will there gonna be any PERFORMANCE issues?<br />
<br />
Regards
</div>
</div>


Hi,

Im FETCHING data from database into a DATASET.

Just want to know: Is there any limit to the amount of RECORDS one can fetch/store in DATASET

DATABASE has got 100,000 records. 

Will it hold that much data ?

Will there gonna be any PERFORMANCE issues?

Regards

DATASET .Net - Number of records LIMIT

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications