I'm working on my Dad's website and he has uploaded hundreds and hundreds of images, all at the original SOOC size. HUNDREDS.
So his site is super duper slow because it has all of these gargantuan images.
I have a workflow to resize all of the images in Photoshop and optimize them for web view, and then I can do a replacement by FTP to the appropriate locations.
The issue is getting the Media Library to recognize the new files, so that it doesn't continue to load the 1542 × 2306 file that I've replaced with a manageable 450 x 600 file. (And where is it keeping that giant file, anyway, once I've replaced it?!)
Is there a reasonable way to do this in bulk or batches, either using MySql or with a plugin I haven't been able to find?
I have installed "Enable Media Replace" (http://wordpress.org/extend/plugins/enable-media-replace/), which will be great going forward, but it only does one file at a time.
Smush.it (http://wordpress.org/extend/plugins/wp-smushit/) is also great, but doesn't change the actual dimensions of the image.