[jboss-user] [JBoss Portal] - Re: Performance Issue with JBP2.7.1; Any workaround??

[Vineet_Tripathi]

checked out the latest code from SVN, build and deploy
(with hypersonic database and  Ehcache, show sql set to true, log statements as specified by vivek, Non clustered server )
created 4 users, went to there dashboard, verified in db the no of dashboards created:


  | select count(1) from JBP_OBJECT_NODE where PARENT_KEY = 8
  |  COUNT(1)    
  |  ----------- 
  |  	4  
  | 
Restarted the server:
login as First user, first access to dashboard, url requested (portal/auth/dashboard):


  | 12:01:37,331 INFO  [STDOUT] before getChild(name);===>
  | 12:01:37,332 INFO  [STDOUT] Hibernate: select objectnode0_.PK as PK9_, objectnode0_."PATH" as PATH2_9_, objectnode0_.NAME as NAME9_, objectnode0_.PARENT_KEY as PARENT4_9_ from JBP_OBJECT_NODE objectnode0_ where objectnode0_."PATH"=?
  | 12:01:37,333 INFO  [STDOUT] Hibernate: select portalobje0_.PK as PK10_0_, portalobje0_.LISTENER as LISTENER10_0_, portalobje0_4_.INSTANCE_REF as INSTANCE2_18_0_, case when portalobje0_1_.PK is not null then 1 when portalobje0_2_.PK is not null then 2 when portalobje0_3_.PK is not null then 3 when portalobje0_4_.PK is not null then 4 when portalobje0_.PK is not null then 0 end as clazz_0_, declaredpr1_.OBJECT_KEY as OBJECT1_2_, declaredpr1_.jbp_VALUE as jbp2_2_, declaredpr1_.NAME as NAME2_, modes2_.PK as PK3_, modes2_.name as name3_, windowstat3_.PK as PK4_, windowstat3_.name as name4_ from JBP_PORTAL_OBJECT portalobje0_ left outer join JBP_CONTEXT portalobje0_1_ on portalobje0_.PK=portalobje0_1_.PK left outer join JBP_PORTAL portalobje0_2_ on portalobje0_.PK=portalobje0_2_.PK left outer join JBP_PAGE portalobje0_3_ on portalobje0_.PK=portalobje0_3_.PK left outer join JBP_WINDOW portalobje0_4_ on portalobje0_.PK=portalobje0_4_.PK left outer join JBP_PORTAL_OBJECT_PROPS declaredpr1_ on portalobje0_.PK=declaredpr1_.OBJECT_KEY left outer join JBP_PORTAL_MODE modes2_ on portalobje0_.PK=modes2_.PK left outer join JBP_PORTAL_WINDOW_STATE windowstat3_ on portalobje0_.PK=windowstat3_.PK where portalobje0_.PK=?
  | 12:01:37,343 INFO  [STDOUT] After getChild(name);===>
  | 
only the select queries corresponding to requested dashboards fired.
First user, second access:

  | 12:04:07,243 INFO  [STDOUT] before getChild(name);===>
  | 12:04:07,243 INFO  [STDOUT] After getChild(name);===>
  | 
  | 
logout first user.
Login as second user:
Second user, First access


  | 12:10:30,827 INFO  [STDOUT] before getChild(name);===>
  | 12:10:30,828 INFO  [STDOUT] Hibernate: select objectnode0_.PK as PK9_, objectnode0_."PATH" as PATH2_9_, objectnode0_.NAME as NAME9_, objectnode0_.PARENT_KEY as PARENT4_9_ from JBP_OBJECT_NODE objectnode0_ where objectnode0_."PATH"=?
  | 12:10:30,830 INFO  [STDOUT] Hibernate: select portalobje0_.PK as PK10_0_, portalobje0_.LISTENER as LISTENER10_0_, portalobje0_4_.INSTANCE_REF as INSTANCE2_18_0_, case when portalobje0_1_.PK is not null then 1 when portalobje0_2_.PK is not null then 2 when portalobje0_3_.PK is not null then 3 when portalobje0_4_.PK is not null then 4 when portalobje0_.PK is not null then 0 end as clazz_0_, declaredpr1_.OBJECT_KEY as OBJECT1_2_, declaredpr1_.jbp_VALUE as jbp2_2_, declaredpr1_.NAME as NAME2_, modes2_.PK as PK3_, modes2_.name as name3_, windowstat3_.PK as PK4_, windowstat3_.name as name4_ from JBP_PORTAL_OBJECT portalobje0_ left outer join JBP_CONTEXT portalobje0_1_ on portalobje0_.PK=portalobje0_1_.PK left outer join JBP_PORTAL portalobje0_2_ on portalobje0_.PK=portalobje0_2_.PK left outer join JBP_PAGE portalobje0_3_ on portalobje0_.PK=portalobje0_3_.PK left outer join JBP_WINDOW portalobje0_4_ on portalobje0_.PK=portalobje0_4_.PK left outer join JBP_PORTAL_OBJECT_PROPS declaredpr1_ on portalobje0_.PK=declaredpr1_.OBJECT_KEY left outer join JBP_PORTAL_MODE modes2_ on portalobje0_.PK=modes2_.PK left outer join JBP_PORTAL_WINDOW_STATE windowstat3_ on portalobje0_.PK=windowstat3_.PK where portalobje0_.PK=?
  | 12:10:30,841 INFO  [STDOUT] After getChild(name);===>
  | 
  | 
Second user, Second access:


  | 12:12:22,037 INFO  [STDOUT] before getChild(name);===>
  | 12:12:22,038 INFO  [STDOUT] After getChild(name);===>
  | 
  | 
Logout second user, Login as First user again :
First access to dashboard:


  | 12:13:54,833 INFO  [STDOUT] session destroyed
  | 12:13:54,835 INFO  [STDOUT] user logout
  | 12:13:54,845 INFO  [STDOUT] session created
  | 12:14:18,574 INFO  [STDOUT] user login
  | 12:14:18,583 INFO  [STDOUT] before getChild(name);===>
  | 12:14:18,584 INFO  [STDOUT] After getChild(name);===>
  | 
  | 

Directly from cache no query fired.

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4229534#4229534

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4229534