Wait. Are you using JAWS? I only ask that because all of the log stuff is from JAWS.
If you are using JAWS, I can't help, because I don't know anything about the JAWS optimized loading process. -dain Frank Morton wrote: >>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 > _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
