在sql server中存储audiofiles和视频文件有什么缺点 [英] what are disadvantages storing of audiofiles and video files in sql server
本文介绍了在sql server中存储audiofiles和视频文件有什么缺点的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我希望以二进制格式存储视频,音频文件,支持二进制数据类型的大小限制。我将来面临哪些类型的问题
表示感谢
pradeep
i want to store video,audio files in binary format,size limit of the binary data type support. which type of problems i am facing in future
regard thanks
pradeep
推荐答案
空间。
所有版本的SQL服务器都有最大的数据库大小 - 版本与版本之间的差异有多大,但在2008R2之前它是4 gB,然后增加到10Gb。 2012的Express版本仍然限制在10GB。使用音频文件不是问题(但如果存储许多文件仍然很重要),但视频文件的重量大约为GB(对于任何好的分辨率),填充SQL数据库并不需要很多。
另外还有备份问题 - 一个巨大的文件比一个较小的文件需要更多的备份时间,并且当时不应该使用。
更糟糕的是,这通常会对SQL性能产生影响 - 大型文件会因查询而占用大量带宽。
就个人而言,我将缩略图存储在数据库中,对于大于100x100 jpg的任何文件本身的文件引用!
Space.
All versions of SQL server have a maximum database size - how big varies from version to version, but prior to 2008R2 it was 4 gB, then upped to 10Gb. The Express version of 2012 is still limited to 10GB. With audio files it is less of a problem (but still significant if you store many files) but with Video files weighing in at around a GB (for any good resolution) it doesn''t take many to fill an SQL database.
Plus there is the problem of backups - a huge file takes more time to backup than a smaller one, and shouldn''t be in use at the time.
And worse, this can really impact on SQL performance generally - large files take a lot of bandwidth to transfer as the result of a query.
Personally, I store thumbnails in the DB, with a file reference to the file itself for anything larger than a 100x100 jpg!
请参阅此链接 -
http://www.aspsnippets.com /Articles/Save-MP3-Audio-Files-to-database-and-display-in-ASPNet-GridView-with-Play-and-Download-option.aspx [ ^ ]
http://sqlserverdiaries.com/blog/index.php/2011/10/saving-a-binary-file -into-sql-server / [ ^ ]
Refer this Link-
http://www.aspsnippets.com/Articles/Save-MP3-Audio-Files-to-database-and-display-in-ASPNet-GridView-with-Play-and-Download-option.aspx[^]
http://sqlserverdiaries.com/blog/index.php/2011/10/saving-a-binary-file-into-sql-server/[^]
这篇关于在sql server中存储audiofiles和视频文件有什么缺点的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文