The finder is executed with on-find strategy, not the on-load you posted
1) because, the finder and instance access is done in different transactions
2) it does prefetch but that is lost because of 1)
read the docs.
Thanks for your reply. I want the finder to execute the on-find strategy. Sorry for the wrong quote.
I have since read the documentation and got rid of read-only. I have instructed that all methods of this been have a transaction attribute of "Required". I have wrapped the client code in a transaction. Still, I see the n+1 behavior. I am probably missing something simple here.
I take that back. I wrapped the client code within a transaction and the on-find started working like a charm!!
Thanks a lot.