如何使用OleDbDataAdapter读取大量数据 [英] how to read large amount of data with OleDbDataAdapter

问题描述

我有excel文件，有2,20,000条记录和40 Mb Size ..我想用OleDbDataAdapter读取这个excel文件，并将结果存储到asp.net中的数据集c＃...这完全在我的本地机器上运行但是当我在IIS 7中部署这个应用程序时，我无法从这个大的excel文件中读取数据，我已经更改了Web配置，并且还使用小数据测试其处理少量数据..我认为这是大量的问题数据...你能帮我解决一下吗？是否在IIS 7中进行了任何更改？

I have excel file which have 2,20,000 records and 40 Mb Size..i want to read this excel file with OleDbDataAdapter and store result into dataset in asp.net with c#...this is perfectly running in my local machine but when i deploy this application in IIS 7, i cant read data from this large excel -file, i already change the web config also and also test with small data its working with small amount data.. i think it is issue of large amount of data...Can you plz help me to solve it out? is that any changes done in IIS 7 or not regarding this ?

推荐答案

有两件事需要考虑：首先，您的IIS设置具有有限的应用程序内存池，并且您的应用可能会超过这个。另一个是处理它们只需要太长时间。



我开始的第一个地方是IIS服务器日志 [ ^ ]确定瓶颈在哪里。



但是......如果你将220,000条记录加载到数据集中，我希望你不要试图全部显示它们 - 如这就是网站设计圈中所谓的用户敌对或只是简单的愚蠢。

Two things spring to mind: firstly that your IIS setup has a limited application memory pool, and your app may be exceeding that. The other is that it is just taking too long to process them all.

The first place I'd start is with the IIS server logs[^] to identify where the bottleneck is.

But...if you load 220,000 records into a dataset, I do hope you aren't trying to display them all - as that is what is known in web site design circles as "user hostile" or "just plain dumb".

这篇关于如何使用OleDbDataAdapter读取大量数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！