Silverlight中的内存不足错误 [英] out of memory error in silverlight

问题描述

嗨 当我上传多个文件超过100 MB并保存在sqlserver中时，我在silverlight中遇到错误，然后发出内存不足异常.我的PC具有窗口7和8 GB RAM的64位.我在上传文件时检查了sql server 2008进程，它占用的内存最多为794.52344 MB(800 MB).如果上传成功并且文件在关闭上传后保存在sql中，则我再次检查sql server保留内存中的794.52344.

因此，请告诉我上传后如何上传超过100 mb的内存和sql server释放内存.

感谢advace
弱ennglish

解决方案

请尝试使用缓冲区以较小的批次加载它.请看以下教程:

http://zombiebob.blogspot.com/2010/08/large-file- upload-in-silverlight.html [ ^ ]

希望这会有所帮助.

更新:好的，因此您的数据库中有一个varbinary(max)字段.创建一个将数据追加到该字段的函数，当您的服务接收数据时，将该数据追加到该字段！请记住，Silverlight是异步的，因此请确保您以正确的顺序发送数据，否则它将中断！

hi i am getting error in silverlight while i upload multiple files more than 100 MB and save in sqlserver then it give out of memory exception. my pc hase 64 bit with window 7 and 8 gb RAM. I check the sql server 2008 process while file uploading it take memory up to 794.52344 MB (800 MB). if upload successfull and file save in sql after closing upload i check again sql server remain take 794.52344 in memory.

So please tell me how i upload more than 100 mb and sql server release memory after uploading.

thanks in advace
sry for weak ennglish

解决方案

Look at using a buffer to load it in in smaller batches. Have a look at the following tutorial:

http://zombiebob.blogspot.com/2010/08/large-file-upload-in-silverlight.html[^]

Hope this helps.

Update: Ok, so you have a varbinary(max) field in your DB. Create a function that appends data to that field, as your service receives data, append that data to the field! Remember that Silverlight is asynchronous so make sure you are sending your data in the right order otherwise it will break!

这篇关于Silverlight中的内存不足错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！