May 10, 2010 at 1:32 am
Hi Everybody
We are in design of a Document Management System. The application is expected to store files of type Office Documents, Images and PDFs and the count of documents would be between 2000 and 3000 per day. I would like to know primarily where the documents to be stored; i.e Store the files in File System or to Store in Database.
If I store the files in Database will the database be able to hold the load.
Experts Please Advise.
Thank You.
Anil
May 10, 2010 at 2:17 am
Since you're using SQL 2008, have you considered FileStream? Best of both worlds - in the filesystem, backed up with the database.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 10, 2010 at 3:54 am
I Haven't. I am new to Filestream. I will go through that. Thank you very much for you insights on that.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply