SQL Server 2008 -- File Stream (3)

●To BLOB or Not To BLOB: Large Object Storage in a Database or a Filesystem

1.Objects smaller than 256K are best stored in a database.

2.Objects larger than 1M are best stored in the filesystem.

3.Between 256K and 1M, the read:write ratio and rate of object overwrite or replacement are important factors. The notion of “storage age” or number of object overwrites as way of normalizing wall clock time. Storage age allows our results or similar such results to be applied across a number of read:write ratios and object replacement rates.

4.Reference http://research.microsoft.com/apps/pubs/default.aspx?id=64525

5.MSDN Article：FILESTREAM Storage in SQL Server 2008

6.MSDN Magazine：Programming with FileStreams in SQL Server 2008

7.RAVI S.MANIAM'S BLOG：FILESTREAM DATA TYPE : SQL SERVER 2008