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 |
|
SQLSeeker
Starting Member
15 Posts |
 Posted - 2010-04-20 : 05:42:28
|
| Hi, In my Application, I want to save word/PDF file to Database. As I know there are two ways by which we can save files. 1) By saving File on Hard Drive and saving Path of the file in database. 2) By using Binary Large Objects(BLOB) Which option is effective performance wise.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-20 : 09:40:22
|
| if you're using SQL 2008, go for filestream access. If not, it might be better to go for filesystem rather than BLOB provided you're ready to manage security aspects access restriction etc yourselves.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Save Word/PDF Document into Database