Hello,
Currently we are in the process of implementing a sql server database where couple tables will have millions of rows ( about 98 millions and will grow) and a web site that will retrieve and sort the data ( read only). How asp.net gridview and sqldatareader act situation like that? Will it be a very slow response? Is there any alternative? Is there any example on the net?
Assuming tables are well tuned and well indexed.
Thank you in advance.
How many of the rows will be displayed in the gridView? (Just an estimate). If there are going to be millions of rows, your best bet will be to implement SQL server side paging of the data. See below:
For use in SQL Server 2005 ONLY
http://www.davidhayden.com/blog/dave/archive/2005/12/30/2652.aspx
For use in SQL Server 2000 and prior versions
http://www.aspfaqs.com/webtech/041206-1.shtml
The search result can bring not less than 5000.
|||I would definitely look into doing server side paging. If you don't do the paging on the server, the ENTIRE result set will have to be transferred over the wire. Even though the gridView handles paging, it will still pull the entire set. With a large result set, the performance will be horrible.
|||I think you answered the wrong question.
I think he wanted to know how many records would be displayed on the grid at one time, which isn't necessarily the same thing as the number of records that qualify according to your search criteria.
If you try to display 5000 rows of data (assuming we aren't talking a simple integer per row) at one time, the slowdown will be in the page rendering, not the data access.
No comments:
Post a Comment