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 de! claredpr1_ 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 de! claredpr1_ 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 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user