On 10/5/06, Larry Meadors <[EMAIL PROTECTED]> wrote:
There are several things you could do here.
Instead of mapping the child results in the config, you could step
through the parent list and use queryForMap() in the dao to populate
the child maps.
You could leave the config as is and walk through the lists and turn
them into maps, that would work ok, and if there are not a ton of
results, that might be easiest.
You could use groupby to do this all in one SQL statement, then walk
through the lists and turn them into maps, which would probably be the
most work, but I think you'd get the better performance that way.
Or you could use a rowhandler and do the object creation
yourself..that would be even more work, but I think you would get the
top performance with that.
Larry
Larry
Thanks for your reply.
I want to know how rowHandler works.
Iin this case, rowHandler will do the same as the select ? I mean, if
I pass my Notification.class to rowHandler query it will use mappings
and return me a Notification object with the List properties filled ?
Thanks in advance
J
