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 |
|
Nicademas
Starting Member
10 Posts |
 Posted - 2009-11-25 : 13:47:47
|
| Good afternoon.I have a question to those in the know about utilizing either of these data types for Word, pdf, etc. types of documents. The documents will range in size from 10KB to at least a couple MB. I'd particularly like to know about any experiences in deciding to choose and the results thereof.In some instances, I could have hundreds of thousands in one column, and therefore in one directory (via FILESTREAM). That sounds like a rea/write nightmare even for NTFS/win32 over db read/writes of binary data.Can anyone speak to experience in utilizing either of these with large volume of documents of various sizes?I will be using this data type from at least one classic ASP application, does that present a problem with the FILESTREAM Data Type? Any thoughts of instead using the old-school way of using NTFS and associating the relational data with the documents via path?Thanks very much in advance for any insights!Nic |
|
|
|
|
|
BLOB, FILESTREAM, or Old-school experiences?