September 19, 2012 at 10:52 am
Hi all!
I am looking for an advice here, not a technical question
I have started working in a company where a regular web application for self-management is used. There are places where files need to be stored by the applications. Currently those files are stored in the server in a path but I have come to think that this is not a good approach, and storing those files in a database would be both safer, and easier to back them up.
Which ins an outs could I face if I change the storing procedure?
Is it best in a path, in a database?
Should I create a different database for the files or just using an existing one?
I really look forward for a little bit of help and any advice will be appreciated,
Thanks!
September 19, 2012 at 11:46 am
You might read this: http://msdn.microsoft.com/en-us/library/cc949109.aspx
If the files are small (250kb or less, stick them in the db.
If they are larger, >1MB, use the filesystem.
A separate database is a good idea, since you can stage backups separately, but then you have the sync issue. How close to being in sync to the rest of the data do you need them.
How does the app access them? If streaming off the file system works, that's good. However you do have the backup/restore and security issues.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply