Good and very thorough article about CMP Beans optimizations.
One question still makes me nervous: If its so hard to do that dance - why bother with CMP?
Moreover most of the "optimizations" are good for any database operations, not only for CMP beans. For example:
Make sure your finder methods use indexes