java - Attachments under File system vs databases? -


I need to mess on the server side. I either store them under the database's Blobes column or under the file directory I can do My question is, who is more reliable, scalable and maintainable?

Edit: -

If we go to the file system, then we have to handle the synchronization ourselves. Isn't it ? For example, if two users are trying to create / update files in the same directory, how will we handle concurrency with file system? Data storage is more reliable due to indexing and receiving data and other operations. Just store the file path in DB and store that file in the directory.

When many data store requests come to the server, it is very difficult and difficult to handle very requests. Therefore it is better to store data on the directory so that access to data is much faster and it becomes very important after increasing the DB storage on a daily scale, when you start all the studies well before any system And then decide what to do or what technology will be the best? When DB has more data, clustering and indexing becomes more important.

If you want to use it for small data storage, this is a good choice, but for larger data I will not recommend you because I have created the online data store web application and face this situation So that in the end I used to store the data in the directory and the path in DB.

Comments

Popular posts from this blog

c - Mpirun hangs when mpi send and recieve is put in a loop -

python - Apply coupon to a customer's subscription based on non-stripe related actions on the site -

java - Unable to get JDBC connection in Spring application to MySQL -