Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sasan_vm
Yak Posting Veteran
51 Posts |
 Posted - 2012-03-06 : 09:44:17
|
| Hello,I have a table in database with BLOB field (IMAGE) , table rows daily increase and database size growth for blob field.I think large database size decrease query performance. What is best solution for this scenario ?Regards,sasan.vm |
|
|
Kristen
Test
22859 Posts |
Posted - 2012-03-06 : 10:38:21
|
| We store images on the filesystem, rather than in the database (we store only the path + filename in the database).But we therefore don't have atomic management of images, which may be important to you?If not I think that storing images in DB is a huge waste of resources! On the filesystem incremental backup of image files (which probably never/rarely change) is easier to manage than having huge database sizes. |
 |
|
|
DoctorDude100
Starting Member
3 Posts |
|
|
|
|
|
Managing Databases with Binary Large Objects