Database design question - binary data

Last Post 03 Oct 2010 06:37 PM by rm. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

01 Oct 2010 11:49 AM
Hi, I have many files being uploaded to a web site and at first decided to save to the file system (mostly pdf's).  I did this so no pressure would be put on the sql server. 

Does anyone have any experience with saving binary data to a table?  First off is it a good idea?  Would it dramatically slow down the server having to serve and save the data?   I know the database could get fairly large.  Right now in the file system I see about 30GB worth of files.

New Member
New Member

03 Oct 2010 06:37 PM
Take look at filestream if you use sql2k8.

Acceptable Use Policy