> 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
Well, I'm using 3.0 as distributed. I assumed if I set cmp-version to "2.x" that I would be using the persistence-manager for Standard CMP 2.x EntityBean, which in standardjboss.xml is org....JDBCStoreManager. So, to answer your question as best I can, I don't think so and I'm thinking if I am, it is by accident and shouldn't be the case. JAWS is for pre-2.0, right? Can you shed light on this? Frank > 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
