Storing image in database vs storing in file system

Question

I am working on a online shopping website, it will have product images also. I have confusion regarding were i should store images. If I store these images in the database image url must be kept into the database and if i store image in blob format i have to decode it before using in php. Can anyone tell which one will be better choice?

Store the image on the filesystem and the URL in the database. — user703016, Jun 25 '12 at 05:18
Oh, btw. Please read this also. http://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay — Aruman, Feb 26 '13 at 16:25

score 6 · Accepted Answer · answered Jun 25 '12 at 05:16

6

I think the best solution is to keep the Database clean of any images. Below are number of reasons -

Database will soon start to grow
File system is good for storing files
You have put extra effort to decode them in PHP(Resource overhead)
Many databases I have studied keep the images in the File System (WordPress source)

Hope it helps

answered Jun 25 '12 at 05:16

Chan

2,601
6
28
45

+1 for this point. "You have put extra effort to decode them in PHP(Resource overhead)" – Aruman Feb 26 '13 at 16:23

Storing image in database vs storing in file system

1 Answers1