Image in database
Posted 26 June 2006 - 02:53 AM
Assuming speed and database size are of equal importance to me, would you suggest - 1. using PHP's image functions to create a thumbnail and insert it into the database or 2. only inserting the fullsize image into the database and then creating a thumbnail from a query of the fullsize.
In option 2, the page that's querying the fullsizes would be querying about 25 images.
Posted 26 June 2006 - 04:09 AM
I would suggest moving away from images in databases if possible, but if you want to stay with images in databases, inserting a thumbnail into the database would most likely be significantly quicker while not taking too much extra space.
Posted 26 June 2006 - 05:08 AM
But just out of curiosity, what's so bad about uploading a file to a database? Isn't that what blob is for?
Posted 26 June 2006 - 08:52 AM
When all else fails - Try reading the manual.
Posted 26 June 2006 - 10:07 PM
As advised as above the filename of the img is faster and less space ok.
((EMAIL CODE THAT WORKS))
((PAYPAL INTEGRATION THAT WORKS))
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users