Take the 2-minute tour ×  I've been working on a SQL model for
my website, and I'm really conflicted on how to store these
images in my database for use around the site.  First, each
profile will contain a relevant 10 images total. 4 screenshots,
with thumbnails, and two extra images. These images will be used
all around the site.  Is storing the image path for each image
in it's own column fine? A buddy tells me that I should place
all images in it's own table and cross-reference them for better
performance. I'll be calling all sorts of information from the
profiles around the same time with the images themselves though.
I'm just wondering what the common practice for something such
as this is.  Again, I'm not storing the actual image in the
database - just the image path.  share|improve this question  2
Answers 2  up vote 3 down vote accepted  Store images on your
file system and store paths in database..  If profile has more
than 1 images then create a separate table for images.  Profile
Table:  id | name