Post reply

Image data type

  • August 10, 2005 at 8:07 pm

    #87092

    Hi Everyone,

    Currently i have an asp web app using sqlserver with over 200,000 image files on a file server that are accessed quite regulary, i was wondering if there would be any advantage in storing the image files in the database under the image data type?

    Thanks in Advance.

  • August 11, 2005 at 12:08 am

    #581282

    From a performance perspective, the answer is no (in normal cases at least). From a manageability perspective, yes and no.

    I usually ask how important the images are. Are they a part of the facts that your database models? What happens if the database suffers some disaster and you need to recover, how will you make sure the integrity of the system maintained? Or even what happens if a transaction is rolled back, for instance after changing an image? If handling these issues are important I say store the images in the database.

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

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

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