I'm working on an application that does not follow the standard e-commerce model. Instead of a ton of connections asking for data only as fast as the users can click, I'm having only a few clients with a need to get a fast a turn around on inserts and selects as possible. Sub 30 ms for every transaction.
I'm thinking that CMP would be nice, since there wouldn't be the extra jump to the database in every case since they are cashed.
However, what's the overhead? And is the Container (any J2EE container) as advanced with thier cashing scheme as Oracle?
Please give me your opinion, and better, if you have actually done some comparison studies, tell me about them!