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 |
|
reddymade
Posting Yak Master
165 Posts |
 Posted - 2005-07-11 : 16:38:59
|
| I do scanning of the documents and saving the images to a folder onWindows OS.We have more than 1 million tiff images in the windows folder.I read in some articles about not to save the images in the database as BLOB objects. These images are like 50 MB size also more than 250 pages in each tiff image.Can you please share your thoughts on this.Thank you very much for the information. |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-11 : 16:41:32
|
| the article is right. Save the file name and the filepath to the database.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me through the forum. |
 |
|
|
reddymade
Posting Yak Master
165 Posts |
Posted - 2005-07-11 : 16:45:58
|
| Can you please forward me any articles where, it says: Not a good practice to use BLOB, I am trying to search but unable to find any on Google.Thank you. |
|
|
|
|
|
|
Is Blob Better or storing images to a Folder