A
Andy
My users need to store and retrieve various files (pdfs, docs, jpegs
etc). I am developing an asp.net 2.0 web application, with SQL server
backend. I've been looking at my best options and am quite new to web
development. I am thinking about this process:
1) Upload the doc
2) zip it
3) Store in the db / on the server
Can anyone give me some advice and pros and cons on the following:
* Storing the file in the database vs storing it on the server
* Zipping the file prior to storing it
I was looking into how to compress files and found that using
GZipStream seemed to make some files larger, so I wonder how much point
there is in that! But I am hoping to slow down the growth of my
database if possible as there are potentially a lot of files that will
be uploaded.
Thanks very much
etc). I am developing an asp.net 2.0 web application, with SQL server
backend. I've been looking at my best options and am quite new to web
development. I am thinking about this process:
1) Upload the doc
2) zip it
3) Store in the db / on the server
Can anyone give me some advice and pros and cons on the following:
* Storing the file in the database vs storing it on the server
* Zipping the file prior to storing it
I was looking into how to compress files and found that using
GZipStream seemed to make some files larger, so I wonder how much point
there is in that! But I am hoping to slow down the growth of my
database if possible as there are potentially a lot of files that will
be uploaded.
Thanks very much