Reduce SQL Filestream limit

• lidds

  Grasshopper

  Points: 12

  More actions

  May 26, 2019 at 9:37 pm

  #3647390

  I want to save images into an sql database, and in my situation the best way to do this is using filestream. The problem is that only images over 2MB are saved to filestream. However my images are smaller than 2MB and I may have around 400000 ages being saved which obviously makes the database large. My question is if there is a way to lower the MB size that is saved the filestream?

• Erland Sommarskog

  SSC-Insane

  Points: 24038

  More actions

  May 26, 2019 at 9:43 pm

  #3647392

  Huh? There is no such limit. If you are only able to save images > 2MB ins size, you are doing something wrong.

  How are you saving the images? Plain INSERT? OpenSqlFileStream? Are you using a FileTable?

  What is the typical size of your images?

  [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]