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 Huh?