padmx82

Hi, I´m currently developing an Image Gallery in PHP and MySQL.

I´m saving the images into the database (using BLOB), what I would like to know is:
Which is the best way to handle the thumbnails for the images, is it better to save the thumbnails into the database also, or generate the thumbnails every time a visitor enter the gallery?

Also, this Gallery will be in a hosting service, so I thought that is better to save the images into the database (considering the amount of storage available), am I correct or should I not save the images into the database but in a folder?

Thanks in advance
Padmx

Sorry for my english, I´m from Mexico

contractfreelancers

Well, by the sounds of things the generation of said thumbnails could create for a very slow site would it not???

Unless of course you have lightning fast code... of course think people could also get annoyed waiting for these thumbnails to generate.

How about you generate the thumbnails once for each separate gallery section, but then after a while of no activity in each section have the site delete them from that unpopular section to save storage space, then, when the next person visits that section it generates them again??? this would then only ever happen once in a blue moon.....

Just a thought.. let me know if you need further clarification.

__________________
Kind Regards,

Liam Twose
CEO - Contract Freelancers
Freelancing / outsourcing for the UK

padmx82

Thanks for your reply, Liam.

Regarding what you said about the speed of the site, in the gallery there will be just 5 thumbs per page (this is because the gallery is actually more like a product image slideshow), so you still think that it will be a slow site? (there will not be much users in the site, I think).


Padmx