Post reply

Storing .jpeg images in and SQL Server Database

  • July 14, 2008 at 3:09 am

    #190670

    I need to store a very large volume of .jpeg images about 5mB each to serve an application. I could either store the images in the database or the store the UNC paths to the images in the database and store the images on the server. Can anyone advise me on the pros and cons?

    Thanks in advance

    Alex

  • July 14, 2008 at 3:19 am

    #842244

    It is generally accepted that it is better practice to store images on the file path,

    Security and backups are two things that you will have to take care of, and you will need a system to ensure your data stays in sync with your database.

    this article summarizes the points nicely;

    http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html

    This is until you get sql 2008 and can use the new FileStream data type.

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

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