sql server - Database grew significantly after adding thumbnails to varbinary(MAX) column? - Stack Overflow

admin管理员组

文章数量:1126344

I have a database that has been in use for a number of years and up to this point we have been storing images (both a full size version and a smaller thumbnail) on the file system. In an effort to improve speed further, we recently moved the thumbnail images (which are only 200 pixels wide) to a varbinary(MAX) column in the database. There are about 40,000 pictures.

On disk, these thumbnail images are about 500 MB. The database, however, grew by 3.5 GB after this change.

Now, the performance improvement we are seeing when retrieving the pictures is well worth the change, but I was surprised by the impact on the size of the database. Is this consistent with what others have seen? Is there an additional maintenance or cleanup step that I should be performing that I may be unaware of?

Our software performs a database backup upon start each morning, which made sense when the database was under 100 MB, but now that it's close to 3.6 GB, isn't as practical... So obviously this will need to be reworked as well.

I would appreciate any experiences or feedback anyone can provide me.

Thanks!

本文标签： sql serverDatabase grew significantly after adding thumbnails to varbinary(MAX) columnStack Overflow