将文件存储在SQL Server中 [英] Store files in SQL Server
问题描述
您好,
除了FileStream之外,SQLServer中存储文件(类型可能是PDF,图像)的可用选项和限制是什么?
What are options available and limitations of each in order to store files (types might be PDF, images) in SQLServer apart from FileStream?
提前致谢。
推荐答案
您好,
Hello,
除了FileStream之外,SQLServer中存储文件(类型可能是PDF,图像)的可用选项和限制是什么?
What are options available and limitations of each in order to store files (types might be PDF, images) in SQLServer apart from FileStream?
提前致谢。
使用数据varbinary的类型(最大)。 唯一的限制是可用的磁盘空间。 将文件存储在文件夹中并通过FileStream或直接访问的速度较慢,但总是需要权衡。 存储的文件越多,
和更大的文件大小就会使您的数据库按比例增长。
Use a data type of varbinary(max). The only limitations are available disk space. This is slower that having the files stored in a folder and accessed through FileStream or directly, but there's always a trade off. Also the more files stored
and larger file sizes make your database grow proportionately.
这篇关于将文件存储在SQL Server中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!