0 Replies Latest reply on Dec 10, 2004 4:56 AM by Zsolt Laszlo

    Loading of CMR fields are very slow

    Zsolt Laszlo Newbie

      Hello

      I have 2 entity beans, equip and block. There is a 1 * relationship between the 2 beans. If e contains 1 row of the equip bean, and I say e.getBlock.getId, first it load the full row form block, and after it it reads the block id from the row. The problem is that the JBoss makes a new query for every row so it is very slow, because I don't need the whole row just the id.

      Please tell me, what can I do. I use Postgre database server and JBoss 3.2.3 Application server.

      Thanks, Zsolt