Storing images in sql server

• Juanita

  SSCertifiable

  Points: 5300

  More actions

  October 7, 2005 at 9:20 am

  #363913

  HI. I have a developer that is rewriting an application. She wants to store the .jpg in sql server. We have never done anything like this. There are about 14,000 images totaling about 58mb in storage.Is it wise to store these images in sql server? Is there a way around this?

  Thanks,

  Juanita

   

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  October 7, 2005 at 10:01 am

  #595925

  http://www.extremeexperts.com/SQL/FAQ/StoreImages.aspx

  This one is important

  http://www.aspfaq.com/show.asp?id=2149

  http://www.sqlteam.com/item.asp?ItemID=986

  http://www.sql-server-performance.com/q&a17.asp

  you can, but not the best idea.

   

• Juanita

  SSCertifiable

  Points: 5300

  More actions

  October 7, 2005 at 10:05 am

  #595927

  Thank you. I actually have been reading since I posted, pretty much the same consensus... I'll pass this article to the developer.

  Juanita