[b]Here's an update that I did to make the database amazingly tiny, faster and more stable.
Google Page Speed site tester here https://developers.google.com/speed/pagespeed/
Gtmetrix Speed tester here https://gtmetrix.com/
Just make sure you test something other than the front page, test something that has 100 images on a page.
These two sites are all you need for web speed optimization.
I had to completely rebuild the database from scratch and the pictures database removed. Something I feared. I had a backup that worked just in case, as well as a complete full metal backup so I took the plunge.
Problem:I was getting very large unedited image\.PNGS when I used the admin panel in Nopcommerce.
admin>Media> Default image quality (0 - 100): WAS 100% NOW 45%
Obviously, we are concerned about garbage in garbage out but 45% seem spot on for me.Since media image size was dropped to 45% it appears the file input closely matched file output.
Your file size may vary but this was very important for me as I had over 150k images.
What I did after a few days (since it was still generating images) in Thumbs\00001_0.png
Yes, my server is atom server the lowest form of server there is but it cost 10 electric per month! Plus I can scale if needed to aws or any other servers. I had switched to file system from database this time!
I crushed the crap out of the PNG images size using at first lossless, then I went bold to lossy 24.
For me, I couldn't tell the difference but my server definitely could. It's much faster and leaner now.
I tried just about every online png to no avail due to file limitation and size limitations then I used ScriptPNG!
ScriptPNG Download here http://css-ig.net/scriptpng
This did a batch png shrink while I did something else. I copied my images folder and specifically my thumbs folder, and saved them locally on a high powered super server. I have 80 core machine that completed the task in a few hours.
Note: ScriptPNg will peg your CPUS at 100% and overheat your machine so you will either need to do 20 mins on and off Or download cupid monitor free version here http://www.cpuid.com/softwares/hwmonitor-pro.html
This will only watch your cpu temps nothing else.
Also you must have speedfan http://www.almico.com/speedfan.php
lower your cpu temps using this. It will still be at 100% but you can drop the temps using this program.
ScriptPNG is no joke. Its super fast and it will get the job done for nop users just beware if using your own equipment! If you can render in the aws cloud do that then no worries.
File optimizer is a program you don't need speedfan . It does a great job of shrinking pngs and jpgs but you may be dead by the time it completes if you have a lot of files.http://nikkhokkho.sourceforge.net/static.php?page=FileOptimizer
Hope this Image shrinkage helps save hours of pain.