> > > That's the reason why all O/R tools that I know of don't implement such a > feature but delegate it to the RDBMS which is optimized for such queries! >
Of course, but apart from query optimisation there are also other issues like network delay which is generally one key reason to cache objects - delegating the complexity to the RDBMS in those cases just moves the problem from query complexity to bandwidth/downtime etc issues. as usual there is no Holy Grail.... Cheers, Chris -- To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
