Post reply

Document Management. Where to Store Documents. In file System or Database.

  • May 10, 2010 at 1:32 am

    #220779

    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

    #1164874

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 10, 2010 at 3:54 am

    #1164895

    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