I’m new to providing image content online and I need to take the right
approach early in my development to avoid any significant performance
or storage hits later on. I’m using Ruby on Rails to provide large
image content on my website. However, I’m not sure if I should store
images on server or in database for faster retrieval. The images that
will be saved are uploaded by website visitors. I tried finding
content online on this subject and I’ve come across the three
- Storing images as binary in the database.
- Storing only the URL of the images that point to the file system
actual image on the server.
- Dynamically build the URL (relative path) of the images that are
saved on the file system under the server.
I would greatly appreciate if you can provide me with your
professional advice on this topic or direct me to good resources where
I can read further on that subject.