I do the basic corrections in RAW, then levels/curves/etc. in PS and save as PSD (16-bit). I do ALL adjustment work in 16-bit. Then I flatten and save as 8-bit JPG which is what I put into iPhoto for preview purposes.
I take it the 8 bit file though isn't 40Mb! 16 bit files are indeed large!