For this example:
<resultMap id=getCategoryResult...>
<result property=id column=CAT_ID/>
<result property=productList column=CAT_ID
select= getProductsByCatId/>
</resultMap>
The sqlmap guide says:
"The only consideration is that if you were to enable
caching, then the using the separate select (not the
join) solution could result in a cached
instance being returned."
While it is not clear, I think it is recommending to
add a cache to the getProductsByCatId method (not the
parent getCategoryResult). Is that correct? I have
many sub-selects and it makes sense to put the cache
there, the only problem being I can never tell when
the cache is actually hit - everything always seems to
go to the DB.
__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
