Well I am trying to make a small social networking application and i will be storing images off-course. I have previously tried storing images using filesystem technique but this time i am thinking of trying the database way .But i am confused. Which way is better .Which one is faster . What are the advantages and disadvantages of both. What technique do major social networking applications use? I'd really appreciate the advice. Thank you.
Asked
Active
Viewed 55 times
0
-
Possible duplicate of [Storing Images in DB - Yea or Nay?](http://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay) – Siv Jun 29 '16 at 00:44
1 Answers
0
I have tried out storing image as blob for one of my projects.
I havent worked on the filesystem storage implementation.
Cons of blob:
- Marginal increase in size of db.
- Slow retrieval rates.
Pros:
- Portable
Hope this reply helps Cheers :)
Siv
- 1,026
- 19
- 29
PrivateOmega
- 2,509
- 1
- 17
- 27
-
Yeah fast retrieval is very important for me so the answer helps :) Meaning of portable? – Syed Muhammad Oan Feb 21 '16 at 15:59
-
-
@MuhammadOan portable is the easiness of transfer to a different enviorment,say you are moving your db to a different server. – PrivateOmega Feb 21 '16 at 16:34
-
retrieval becomes slow for large data sets. for small projects it doesnt matter.i myself have used blob storage for my project.. – PrivateOmega Feb 21 '16 at 16:35
-
-
@SyedMuhammadOan - http://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay : Do avoid duplication of questions. Hope it helps more! – Siv Jun 29 '16 at 00:46