File Upload

  • Thread starter Thread starter Anil
  • Start date Start date
A

Anil

Hi,

What is a better way of storing a document file ? using a File Server or
storing the file in a SQL Server DB as a BLOB ? considering that the volume
of data and traffic on the site is pretty high ...

Also how can we automate a virus check while uploading of a file ?
thanks
 
Anil,

Personally, if I didn't have to query on properties of the file, all I
was doing was serving up the file, then I would probably use just the FS.
Some OSs (starting with W2K I believe) allow you to optimize their
performance for file serving, and I would want to take advantage of that.

If I had to work with the file, or have extra attributes attached to it,
then I would store it in the DB, all in one place.

Hope this helps.
 
Again,build for what makes sense for your app (like Nick mentioned for extra
attributes -- also consider security, syncronization, etc.). The FS is
going to have some good caching going on, but then again, the DB server
should be able to do this too. Also remember that you can write your own
caching system and that way you can even further increase performance.

Of course, the real way is to measure, measure, measure. Try using the DB
if you have any attributes to go along with the data. If you're definately
missing performance goals, see if other ways (you own caching) helps enough.
If your performance goals are still not met, then perhaps consider other
stores.

-mike
MVP
 
Back
Top