> 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

Reply via email to