guforosso posted 5 years ago in Feature discussion
i have insert image into db use a compress function
set ...field=compress(image_binary_data) to display img i use uncomprss(field) AS img, the db size is reduced file size at 1% to 3%
to display image/fileld is possible to add feature compress
and/or decrypt ?
jfalch posted 5 years ago
images (e.g. .jpg, .gif) are often stored as files that are already compressed internally; compressing them again will yield only a very small size change, as you have observed.
compress() will usually make data smaller, ie is a compression method built into mysql (usimg the zlib algorithm); it only doea not work well on already pre-compressed images.
TTSneko posted 5 years ago
I know this is an old post, but a friend came up with the same question not too long ago:

Normal JPG images contain a normally completely useless 'add-on' which can be easily removed: the EXIF information block. Depending on size of the images, the removal of the EXIF info yields far better results than *ANY* compression, in my case tons of images the range of 25-30kb were left at roughly 8kb each (one third of the previous size!).

Google for tools that allow batch functions in this matter. I have Win7-64bit and still use the CMD-line (DOS-box) tool "JHEAD" as it works in batches (even though I mostly use it as button function from my file manager) ...

And no, dropping the EXIF data does not ruin or otherwise render a JPG file useless; the files are not even 'written' (re-compressed) again during the process, hence there is also no further quality loss.

Please login to leave a reply, or register at first.