Hello, my company is thinking in make a document repository application and I have read many times that its not recommended to save the files to the database, because it adds ovverhead to other users that are using transactions or something else.
I need to convince my boss that its a bad practice to put the files on BLOB fields inside the database.
Any ideas!!
Well, my first question would be "how would you plan on getting them OUT of the database?". That is always the problem with BLOBs.
In order to display the "file" from the BLOB, you will need to convert it back to a file. So just keep it a file, and use the database to index to it. If you are concerned about security, then create a process which copies the file from a secure area to a place the user can get it, and then delete it when done.
No comments:
Post a Comment