> Dain wrote: > BTW: there is a difference between doesn't work and is not fast enough > for me.
You are right about that. With all the weird things I have tried on this, I have never gotten an exception that I didn't cause which is a real testimony to the stability of 3.0.0.RC1. > Have you looked at the server.log? What queries are being executed? > Don't post the whole file. Give us a summary. Here is the log where I invoke the stateless session bean that first does a find on a Container, then finds a Collection of Attribute beans. I'm after the "name" property in each Attribute. It is doing individual selects on each Attribute in the Collection. I guess my bottom-line question is if cmp can be coaxed into loading the Collection with a single Select since it takes around 100ms per select, leading to about 20 seconds for a Collection of 200. I'll try any idea you may have. Wow does that leave me open for comment ;-) Frank 2002-04-24 10:02:37,151 DEBUG [org.jboss.ejb.plugins.LogInterceptor] Invoke: [1] getProfileHandle() 2002-04-24 10:02:37,153 DEBUG [org.jboss.ejb.plugins.LogInterceptor] Invoke: [1] getId() 2002-04-24 10:02:37,154 DEBUG [org.jboss.jetty.util.NaiveTimeOutManager] background thread started: org.jboss.jetty.util.NaiveTimeOutManager@7b914d 2002-04-24 10:02:37,248 DEBUG [org.jboss.ejb.plugins.LogInterceptor] Invoke: [1] getId() 2002-04-24 10:02:37,311 DEBUG [org.jboss.ejb.plugins.LogInterceptor] InvokeHome: create() 2002-04-24 10:02:37,318 DEBUG [org.jboss.ejb.plugins.LogInterceptor] Invoke: findByPrimaryKeyMap(1004976,name) 2002-04-24 10:02:37,379 DEBUG [org.jboss.ejb.plugins.LogInterceptor] InvokeHome: findByPrimaryKey(1004976) 2002-04-24 10:02:37,383 DEBUG [org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] Exists command executing: SELECT COUNT(*) FROM Container WHERE id=? 2002-04-24 10:02:37,383 DEBUG [org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] Set parameter: idx=1, jdbcType=BIGINT, value=1004976 2002-04-24 10:02:37,387 DEBUG [org.jboss.jetty.util.NaiveTimeOutManager] background thread ended: org.jboss.jetty.util.NaiveTimeOutManager@7b914d 2002-04-24 10:02:37,420 DEBUG [org.jboss.ejb.plugins.LogInterceptor] InvokeHome: findByContainerId(1004976) 2002-04-24 10:02:37,423 DEBUG [org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] findByContainerId command executing: SELECT id FROM Attribute WHERE containerId=? 2002-04-24 10:02:37,423 DEBUG [org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] Set parameter: idx=1, jdbcType=BIGINT, value=1004976 2002-04-24 10:02:37,555 DEBUG [org.jboss.ejb.plugins.LogInterceptor] Invoke: [1006166] getName() 2002-04-24 10:02:37,556 DEBUG [org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] Load command executing: SELECT Attribute.id,Attribute.containerId,Attribute.name,Attribute.value,Attribute. containerType FROM Attribute WHERE id=? 2002-04-24 10:02:37,556 DEBUG [org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] Set parameter: idx=1, jdbcType=BIGINT, value=1006166 2002-04-24 10:02:37,623 DEBUG [org.jboss.ejb.plugins.LogInterceptor] Invoke: [1006167] getName() 2002-04-24 10:02:37,624 DEBUG [org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] Load command executing: SELECT Attribute.id,Attribute.containerId,Attribute.name,Attribute.value,Attribute. containerType FROM Attribute WHERE id=? 2002-04-24 10:02:37,625 DEBUG [org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] Set parameter: idx=1, jdbcType=BIGINT, value=1006167 2002-04-24 10:02:37,685 DEBUG [org.jboss.ejb.plugins.LogInterceptor] Invoke: [1006168] getName() 2002-04-24 10:02:37,688 DEBUG [org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] Load command executing: SELECT Attribute.id,Attribute.containerId,Attribute.name,Attribute.value,Attribute. containerType FROM Attribute WHERE id=? 2002-04-24 10:02:37,689 DEBUG [org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] Set parameter: idx=1, jdbcType=BIGINT, value=1006168 2002-04-24 10:02:37,768 DEBUG [org.jboss.ejb.plugins.LogInterceptor] Invoke: [1007007] getName() 2002-04-24 10:02:37,771 DEBUG [org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] Load command executing: SELECT Attribute.id,Attribute.containerId,Attribute.name,Attribute.value,Attribute. containerType FROM Attribute WHERE id=? 2002-04-24 10:02:37,771 DEBUG [org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] Set parameter: idx=1, jdbcType=BIGINT, value=1007007 2002-04-24 10:02:37,839 DEBUG [org.jboss.ejb.plugins.LogInterceptor] Invoke: [1007008] getName() 2002-04-24 10:02:37,840 DEBUG [org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] Load command executing: SELECT Attribute.id,Attribute.containerId,Attribute.name,Attribute.value,Attribute. containerType FROM Attribute WHERE id=? 2002-04-24 10:02:37,841 DEBUG [org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] Set parameter: idx=1, jdbcType=BIGINT, value=1007008 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user