|
-
May 15th, 2013, 02:22 PM
#1
Thread Starter
Lively Member
use filestream or not?
I'm building a sql server 2008 r2 database to store blob data for an imaging system. This link (http://technet.microsoft.com/en-us/l...=sql.105).aspx) recommends using the filestream functionality if on average my objects are larger than 1 mb, otherwise it says to just store the data in the table. My historical data to this point is as follows: 1,453,970 objects, 1,402,778 smaller than 1 mb, 51,192 larger than 1 mb, average size (simply total mb/number of objects) is .26 mb. The large objects range anywhere from just over 1 mb all the way to 387 mb on the extreme end (there is only 1 of those). Does anyone have any recommendations to offer based on my data of whether I should use filestream or not based on their experience? Thanks in advance.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|