-3
How best to store files on a server, such as binary in a database or save it in directories. There is some difference between processing cost in a web application?
1 answer
0
It all depends on the solution you want to implement and what resources you already have. Storing in the Database is a good idea, it has no great impact on performance (contrary to what many people think - at least in SQL Server), as long as SELECT includes as few times as possible the field in which it contains the file. But you have the problem of limiting the Database itself. That is, depending on the SQL Server license you have, this may or may not be a good idea.
If you choose to save outside the Database, you should also think about how you will manage the addresses. Because, "any" user with access to the folder, can perfectly change the name of the file, put in another folder, etc, and all this without updating the mapping in the Database.
There’s still Cloud’s solution, which is another story.
Browser other questions tagged database server-client
You are not signed in. Login or sign up in order to post.
Hi, Funke, asking an answer based on just two sentences is not exactly a good question... Which server do you use? Have you tried binary or directory? Why do you think it’s going to cost? etc... If you know English, reading this is kind of essential: Writing the Perfect Question
– brasofilo
Possible duplicate of It is wrong to write byte of images in the database?
– rray