May 26, 2019 at 9:37 pm
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?
May 26, 2019 at 9:43 pm
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]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy