Database design question - binary data

Last Post 03 Oct 2010 07:37 PM by rm. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
cmessineo
New Member
New Member

--
01 Oct 2010 12:49 PM
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.

Thanks
rm
New Member
New Member

--
03 Oct 2010 07:37 PM
Take look at filestream if you use sql2k8.
You are not authorized to post a reply.

Acceptable Use Policy