大数据源的错误
我正在对大型数据源进行一些基准测试并绑定/导出数据以进行报告。
我首先使用一个数据集，用 100000 行填充它，然后尝试使用检索到的数据打开一个水晶报表。我注意到数据集填充得很好（大约花费了 779 毫秒），但是，当尝试将数据导出到报表或什至绑定到 gridview 时，应用程序将失败并出现 OutOfMemoryException。
有没有人以前经历过这个或者知道如何解决它？客户很可能会运行包含多年数据的报告，并且 100000 行也不是不可想象的。
应用程序和基准测试代码是使用 ORACLE 和 SQL Server 数据库用 C# 编写的。我仍然有一些数据源需要测试，但想知道如何解决这个问题，以防我找不到更好的解决方案。
请注意，这是为了报告而不是实际的网格视图。
I'm doing some benchmarking on large data sources and binding/exporting data for reporting.
I started with using a data set, filling it with 100000 rows and then attempting to open a crystal report with the retrieved data. I noticed that the data set filled just fine (took about 779 milliseconds) however, when attempting to export the data to the report or even bind to a gridview the application would fail with an OutOfMemoryException.
Does anyone experienced this before or have an idea of how to get around it? It is very possible that clients will run reports for years worth of data and 100000 rows are not inconceivable.
The application and the benchmark code are written in C# using ORACLE and SQL Server databases. I still have some data sources to test, but would like to know how to get around this just in case I don't find a better solution.
PLEASE BE AWARE THIS IS FOR REPORTING NOT ACTUAL GRID VIEW.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
没有一个理智的人会用 100000 行填充一个 gridview。如果您不确定如何操作，请实施分页或购买提供开箱即用分页功能的组件
No sane person would fill a gridview with 100000 rows. Implement paging or buy a component that offers paging out of the box if you are not sure how to do it