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 |
|
lionofdezert
Aged Yak Warrior
885 Posts |
 Posted - 2009-09-08 : 04:43:33
|
| We have a target to scan and save our office documents, each file size is up to 300 Kb and Total size will be approx 3 Tera bytesMy question is, what will be the best practice...1-Should we save these images in database, in column as binary data ???OR2-Should we save these images as separate files and keep their reference in database ???(No data updates will be required, Only one time data insertion so there are less chances of fragmentation or other performance issues) |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-09-08 : 04:46:39
|
Move to 2008 and use the FILESTREAM.  Personally, if you are going to stick with 2005, I would save them on the filesystem, but thats what I feel better doing, this way, you don't have to convert anything (they can stay as their original file types). |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-08 : 04:49:13
|
I would never pump up my database with information like this unless I have a good reason for that.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Image data