亚音速内存不足异常
我目前正在使用 Subsonic 2.1,当我尝试使用 Subsonic 从 SQL 数据库表中提取大量数据(@ 140,000 条记录)时,我收到一条错误消息。 我是否需要更改配置设置,以便为我的应用程序分配更多内存来完成任务?
I am currently using Subsonic 2.1 and I am receiving an error message when I attempt to use Subsonic to pull back large amounts of data (@ 140,000 records) from an sql database table. Is there an configuration setting that I need to change in order to allocated more memory for my application to complete the task?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
问题是 - 为什么要打开 140,000 条记录?
如果您正在进行数据挖掘、报告或进行大数据传输,我建议您不要使用 Subsonic,而是使用更适合的工具。
The question is - why are you opening 140,000 records?
If you are data mining,reporting or doing big data transfers, I would suggest that you don't use Subsonic for this, but use a better suited tool.
对我来说,这个问题是由臃肿的数据库文件引起的。 我能够通过全新安装来修复它。 我在这里写了更多相关内容: https:// zachsaucier.com/blog/subsonic/#the-biggest-problem-ive-had-with-subsonic
For me, this issue was caused by a bloated database file. I was able to fix it by doing a clean install. I wrote more about it here: https://zachsaucier.com/blog/subsonic/#the-biggest-problem-ive-had-with-subsonic