Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   ASP .Net (http://www.velocityreviews.com/forums/f29-asp-net.html)
-   -   Should heavy binary files not be stored in database? (http://www.velocityreviews.com/forums/t957032-should-heavy-binary-files-not-be-stored-in-database.html)

Big George 01-28-2013 08:16 PM

Should heavy binary files not be stored in database?
 
I was asked an interesting question: Should a database contains all
data? Or heavy binary files should be stored in file system?

Example of heavy binary files : videos or heavy pdf files (+200 MB)

With an old aspx web app (1.1) I tried to open a 200MB pdf file stored
as a blob in an Oracle 11g database, and it just couldn't do it.

However, same asp.net web application had no problem to open same pdf
file stored in file system of a server. It could be that maybe there
is some proper way to open heavy blobs fields with asp.net.

For integrity reasons, I say that all data should be stored in
database, but my described case showed me that maybe it's not the way.

I read once that if your web application goes to cloud, then it would
be very difficult to keep references of files stored in file system
(file paths like: ../MyFolder001/MyFile.mpg), since you don't know
where those files will be distributed.

What do yo think?

Arne Vajh°j 01-28-2013 10:33 PM

Re: Should heavy binary files not be stored in database?
 
On 1/28/2013 3:16 PM, Big George wrote:
> I was asked an interesting question: Should a database contains all
> data? Or heavy binary files should be stored in file system?
>
> Example of heavy binary files : videos or heavy pdf files (+200 MB)
>
> With an old aspx web app (1.1) I tried to open a 200MB pdf file stored
> as a blob in an Oracle 11g database, and it just couldn't do it.
>
> However, same asp.net web application had no problem to open same pdf
> file stored in file system of a server. It could be that maybe there
> is some proper way to open heavy blobs fields with asp.net.
>
> For integrity reasons, I say that all data should be stored in
> database, but my described case showed me that maybe it's not the way.
>
> I read once that if your web application goes to cloud, then it would
> be very difficult to keep references of files stored in file system
> (file paths like: ../MyFolder001/MyFile.mpg), since you don't know
> where those files will be distributed.
>
> What do yo think?


I am in general a big fan of storing files in the database
instead of in the file system.

But with 200+ MB files, then I would consider going for the
file system.

With a big DB server then I would still say DB, but
with a small DB server, then I would go for the file
system.

10000 files x 200 MB = 2 TB data

I would not worry about cloud. Most cloud solutions
offer both database and "non database BLOB storage".

Azure (which is most relevant for ASP.NET) has SQL, Tables
and BLOB storage:

http://www.windowsazure.com/en-us/ho...ta-management/

Arne




All times are GMT. The time now is 06:32 PM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.