访问文件系统中的文件与Sql Server 2008 R2中的已保存文件 [英] Accessing files in File System vs Saved file in Sql Server 2008 R2

问题描述

大家好.

我有大约1亿张图像(每个图像的大小小于10K，平均6K)意味着大约570GB，此刻，我已将所有图像存储在一张表中的SQL Server 2008 R2中.
我的问题是，哪种方式可以更快地访问它们?

1.图像保留在带有asp.net页或Web服务的sql服务器中，用于访问具有给定图像名称或ID的每个图像. (也许使用某些技术，例如将sql服务器分布在多个服务器上或MS SQL Server并行数据仓库中)

2.将所有图像提取到文件系统并通过IIS访问它们?
我最关心的首要问题是访问速度.

解决方案

^ ]
http://forums.asp.net/t/1096999.aspx [ Google [如何将二进制数据存储和提取到文件流列中 [ ^ ]

Hi every body.

I have about 100,000,000 images (each one''s size less than 10K , averagely 6K) means about 570GB and at the moment i had stored all of them in SQL Server 2008 R2 in one table.

my question is that which way has better speed in accessing them ?

1. Images stay in sql server with a asp.net page or web service for accessing each image with a given image name or id. (maybe using some technics like distributing the sql server on several servers or MS SQL Server parallel data warehouse)

2. Extracting all images to file system and accessing them via IIS ?

my first and important concern is about accessing speed .

解决方案

http://stackoverflow.com/questions/3304588/store-user-profile-pictures-on-disk-or-in-the-database[^]
http://forums.asp.net/t/1096999.aspx[^]
Google[^] for more...

I''ve done some comparison in binary data performance in Sql Server. Perhaps it would be of some use: How to store and fetch binary data into a file stream column[^]

这篇关于访问文件系统中的文件与Sql Server 2008 R2中的已保存文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！