I'm implementing SQL Filestream which is similar to BLOB and I was looking at this http://technet.microsoft.com/en-us/library/cc645962.aspx
It says updating filestream data via sql shouldn't be done for large file sizes. I'm not actually planning to update data, but I'm wondering if it will be slow to insert. I'm also wondering what the appropriate way to upload and access the data. I would
think it be adding the file data onto a simple sql statement, but I keep seeing things like this http://geekswithblogs.net/dnoderer/archive/2008/11/05/sql-server-2008-filestream-and-vb.net.aspx and see a lot of steps to do it. So, I'm a bit confused what's
the appropriate approach.
mtewks
Member
431 Points
308 Posts
Uploading and Accessing SQL Filestream Data
Mar 28, 2012 03:41 PM|LINK
I'm implementing SQL Filestream which is similar to BLOB and I was looking at this http://technet.microsoft.com/en-us/library/cc645962.aspx
It says updating filestream data via sql shouldn't be done for large file sizes. I'm not actually planning to update data, but I'm wondering if it will be slow to insert. I'm also wondering what the appropriate way to upload and access the data. I would think it be adding the file data onto a simple sql statement, but I keep seeing things like this http://geekswithblogs.net/dnoderer/archive/2008/11/05/sql-server-2008-filestream-and-vb.net.aspx and see a lot of steps to do it. So, I'm a bit confused what's the appropriate approach.