Post reply

Store Images in Database?

  • June 29, 2005 at 7:58 am

    #164768

    Hello All,

    I needed your advice on something that I have been thinking off. We have images, large(40K each) and thumbnail(10K) which are currently stored on a NAS - there are approx million jpgs for each, that is large and thumbnail. We also have around 500,000 attachments that are also stored on a NAS. My backups take forever on these and while testing a restore, it took forever as well.

    I know storing this type of data in the database is not a good idea, or at least thats what I think. I have never tried it so I don't know. For simplifying the management of these, I was thinking if I was to do this, I would store these in a different database, but on our main Prod database. Just wondering if someone has done this and what are the potential pit falls and performance issues they faced and what they did to resolve it.

    Thanks in advance.

    Vik.

  • June 29, 2005 at 12:43 pm

    #569513

    I am sorry - looks like I posted this in the wrong place - moving this thread to --> SQL Server -->administration.

  • June 29, 2005 at 1:11 pm

    #569531

    Here to be exact :

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=195400

  • June 29, 2005 at 2:28 pm

    #569569

    Thanks Remi

  • June 29, 2005 at 2:29 pm

    #569570

    NP.

Viewing 5 posts - 1 through 4 (of 4 total)

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