在sql server中存储audiofiles和视频文件有什么缺点 [英] what are disadvantages storing of audiofiles and video files in sql server

问题描述

我希望以二进制格式存储视频，音频文件，支持二进制数据类型的大小限制。我将来面临哪些类型的问题





表示感谢

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屋！