Is there any way to compress image files after they've been loaded by user on server?

sameerpanjwani

I am limiting the upload size of each file to 100kb and each user can upload upto 5 picture files. However, I'd like to know if after they've uploaded the file whether I could possibly optimise the size / compress the image file after it's been loaded onto my server?

Just another question to add, is it better to store images in MySQL or just as a link in the database?

Weedpacket

There are sure to be JPEG and PNG optimisers around (the name "pngcrush" springs to mind); they'd be separate programs which you'd use system calls to run. See what Google throws up.

Store the image files in the file system, and their paths in the database. If you stored it in the database the database still has to be stored on the filesystem anyway, so what are you gaining? It's not like you can search on or index by them.