I am trying to create a photo gallery using MySQL and PHP.
I want to know your opinions on this design issue:
I have a table called ‘gallery’. This contains info on all photo galleries: date, location, etc.
What is most efficient:
A) Create a separate table per 'Gallery’ record to hold all ‘Photos’ in each gallery.
B) Create 1 big Table name ‘Photo’s’ with all photos, and a ‘**Gallery’ ** key in ‘Photo’s’ to reference the ‘Gallery’ table.