Short Answer, Automator:
Long Answer: iPhoto cannot create a smart album based upon File Size, so you'll have to either group them by other means or manually create an Album with the offending photos (the big ones). Automator, on the other hand, is perfectly capable of finding iPhoto images by size (and by Rating stars).
The first thing you have to decide is: Do I want to scale my images down? Do I want to make them JPG instead of whatever format they have? Do I want to do both for maximum effect? That is, you have to decide what's the best optimization for your photos that has a balance between quality/size.
Each of those have consequences: if you don't save a copy of the original photo, and the resulting quality is not something you like, there's no turn back (unless you have a TimeMachine or similar backup of course).
In any case, Launch Automator, create a new "Workflow" and add the following actions:
NOTE: I've removed the "Make copy" actions that Automator asks you to place by default when an operation will "affect" files, but leave those to "experiment" so you don't alter
your original images, at least until you're satisfied with the results.
I suggest you try with a small set of images before going Coo-Coo with the whole Library. As in create a small album with some of the "big" images and try from there. You don't want to wreck your iPhoto library…
This should preserve all the metadata and original photo, while making a Batch adjustment.
If you have programs like Pixelmator or Acorn, you will have more automator stuff there. The more the merrier.
As forbca said in his/her answer in the support thread you linked to, the issue seems to be resolved if you reboot.
I had the same issue. After a reboot, I'm able to import the photos correctly into iPhoto. Just grab the originals and re-import them in iPhoto. You'll be asked about duplicates – import the portrait photos anyway.
It seems to be a bug in an iPhoto update that only turns up if you haven't rebooted since the update. The corrupted imports were done on a laptop that had over 30 days of uptime.
Best Answer
You can, but you'll lose metadata such as albums and you might end up with duplicated photos if you import both the modified and the original.
Instead, you can use the iPhoto Library Upgrader to prepare the library for import into Photos directly. This Apple tool takes your pre-'09 library and allows it to be imported into Photos. For more information on how to use the iPhoto Library Upgrader, see Using the iPhoto Library Upgrader tool.
Pre-'09 is v7.x and earlier. v8.x and later can be imported directly with Photos without this tool.