如何在几秒钟内在gridview中绑定10万条记录 [英] how to bind 1 lakh records in gridview within few seconds

问题描述

如何从SQL Server数据库，asp.net，c#中以技术绑定到网格视图中的10万条记录

how to bind 1 lakh records in gridview from sql server database, asp.net, c# as technologies

推荐答案

无需绑定一条10万条记录.您在5秒钟内读取了1条记录，则需要138.888889小时或5.78703704天才能读取100000条记录...您是否认为有人会完全读取它???? ..而是使用gridview分页或搜索功能或用于过滤和显示所需记录的下拉列表..

具有分页和过滤功能的自定义GridView [

No need to bind one lakh records.. If you read 1 record in 5 seconds, it will take you 138.888889 hours or 5.78703704 days to read the 100000 records... Do you think somebody is going to read it at all ????.. Instead use gridview paging or search functionality or dropdowns for filtering and displaying the required records..

Custom GridView with Paging and Filtering[^]

Also, if each record occupies a 1 KB on your page, it will be a 100 MB page. Now you need a 100*8 = 800 Mbps connection to download this amount of data in one second OR a 125 Mbps connection to download this on page in 5 seconds. Note that I have not counted the processing time of your server and local machine..

And yes, even if you are successfull in displaying all the 1 lakh records on the page, with about 30 records per page, it will count to 3333 pages to scroll... Get ready for a scroll marathon...

这篇关于如何在几秒钟内在gridview中绑定10万条记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！