Todd- The cold rooster storage sample app shows their method for storing large image files in a database and WHY they chose that over just straight file storage. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dncold/ html/storagedbdsgn.asp. You can upload up to 2G at a time. Can you imagine? They also have a lot of analysis of how they came to this methodology. I love this sample. Well, I love anything in the Patterns & Practices area. They don't just do it, but they really try to go over the pros and cons.
I've been storing xml and image files in sql server but nothing so large. However, this article was a huge help to me in terms of giving me confidence that the database was the right choice. Pushing that envelope sounds like fun! Now I'm definitely curious to possible distraction! julie -----Original Message----- From: Moderated discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Todd Hickerson Sent: Tuesday, May 27, 2003 7:35 PM To: [EMAIL PROTECTED] Subject: [ADVANCED-DOTNET] Large Object Reading/Writing I am debating using the SQL Server 2000 database or the file system to store large objects (image datatype) and would like to find some discussion about the reading/writing techniques when the files are 300-500 MB. Most of the time the files will be a few MB to tens of MB; however, some could be hundreds of MB. Once the file is read from the database or filestream, it will be sent via a TCP .NET Remoting service to another TCP .NET Remoting Service to reconstitute the file on the other end. There is really no need to reconstitute the file before it is sent across the internet if it is retrieved from the database. But, with files that large, I'm not sure what technique to use to read the data from the database, much like you would use a FileStream object to read an array of bytes from the file system. I'm wondering if the SqlDataReader would be viable. One problem is that the "Read" method appears to be row based, in which case the entire row could be 500MB. If anyone has any experience with this or articles you could recommend, I would be grateful. Thanks, Todd Hickerson (Also posted on the OLEDB list)
