SQL Server 2008 Filestream : Why?

Why would you want to use filestream in SQL Server 2008?

The files you store using filestream in SQL Server 2008 are not accessible directly using the normal io methods.Instead you have to make a SQL call to get a pointer which you can then use with normal methods.

So if you have to access SQL anyway why not store the data directly in SQL in the say a varbinary(max) field?

The answer is performance.

Jim Gray and his colleagues did research into the storing of large data in the database (SQL2005) versus the file system (NTFS).

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

In this research it showed that storing anything less than 256Kb was better done in the database, and anything larger than 1M should be stored in the file system. In between depended on the read/write ratio, and storage age.

So if you need to store data blobs that are > 256Kb (per instance) you need to consider filestream.

[18/12/2007 Link fixed]



-
Published Monday, December 17, 2007 11:24 PM by simonsabin

Comments

Tuesday, November 18, 2008 2:29 PM by Zuker On Foundations

# SQL 2008 - Filestream vs. Blob

Read the full details here . In essence: Filestream will save the files on the filesystem giving you

Thursday, January 15, 2009 1:26 PM by Zuker On Foundations

# SQL 2008 - Filestream vs. Blob

Read the full details here . In essence: Filestream will save the files on the filesystem giving you

Wednesday, May 13, 2009 7:06 PM by SQL Server

# Datos binarios, archivos e imágenes dentro de la base de datos?

Para SQL 2005 la opción era guardarlos como campos tipo binary o tipo image. Para SQL 2008 se puede utilizar

# Datos binarios, archivos e imágenes dentro de la base de datos? « Eduardo Castro Blog

Pingback from  Datos binarios, archivos e imágenes dentro de la base de datos? « Eduardo Castro Blog