[JBoss-user] [Persistence & CMP/JBoss] - Re: curious SQL-Statements when loading related data

[lafr <nu...@jb...>]

I think you misunderstood the problem description.
My problem is not the where clause of the statement.

The problem is, that the first access gets the PK-field plus first additional field, the second access reads the same rows, but know the PK-field plus second additional field, and so on and so on.
I expected 5 select to read the 84 rows with max 20 at a time (4x20+1x4).
Instead I get 315 selects (factor 63 because of 63 additional columns in afpos).


View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835595#3835595

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3835595