Re: n+1 is triggering multiple queries, 3?

2005-07-14 Thread Kris Rasmussen
Thanks Clinton, I will look into this myself when I have more time. I wish there were a MySql Profiler or something so that I could see what queries are actually being executed. Maybe I will step into your code if I get a chance. KrisClinton Begin [EMAIL PROTECTED] wrote: Kris,This is the right

Re: n+1 is triggering multiple queries, 3?

2005-07-14 Thread Larry Meadors
p6spy is also a great sql logging tool. On 7/14/05, Ron Grabowski [EMAIL PROTECTED] wrote: The Java version of iBATIS has support for logging all sql sent to the database. Here's some sample output: http://issues.apache.org/jira/browse/IBATISNET-35 --- Kris Rasmussen [EMAIL PROTECTED]

n+1 is triggering multiple queries, 3?

2005-07-09 Thread Kris Rasmussen
I have an n+1 mapping. When I look at mysql health in the administrator it apears that 3 queries are being executed instead of one. The first query gets executed when I retrieve the intial object via queryForObject. The next two queries are being executed when I attempt to access the List which