Together with some friends i'm making a simple 'flickr' website, where people can upload their pictures.
On this site we also want to display some exif data (photo information), which can be extracted from the photo's themself. There are two way's I can do this:
When the user uploads a picture, my php script will obtain the exif data and write it in the database. When a visitor comes accross the picture the exif data will be retrieved from the db.
When a visitor comes accross the picture, the exif information is being pulled from the photo on the fly.
Which of both options would be more efficient (faster), when a couple of hundreds/thousands of photo's will be viewed every day ?