Post reply

save pictures in database or to file?

  • May 22, 2011 at 9:07 pm

    #240958

    hi'

    In a database project which use of pictures, Is it better to save pictures in database or to file?

    thanks very much

  • May 22, 2011 at 10:18 pm

    #1328279

    Check FileStream in the test environment.

    It has benefits of storing the picture (binary data) in the database as well as disk file.

  • May 23, 2011 at 11:13 am

    #1328604

    armm1388 (5/22/2011)

    hi'

    In a database project which use of pictures, Is it better to save pictures in database or to file?

    thanks very much

    It depends on many things. FILESTREAM is an option. Storing the image binary itself in a VARBINARY column is also an option.

    1) What is the average size of the pictures?

    2) Will you be updating images on a regular basis?

    Here is an excellent whitepaper on the topic. It will familiarize you with the things you need to consider before making a decision however it was written in 2006 so beware that conclusions may not be relevant for SQL 2008 or SQL 2008R2:

    http://research.microsoft.com/apps/pubs/default.aspx?id=64525

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply