[jboss-user] [JBoss Seam] - Re: Seam + EJB3 performanceL
do-not-reply at jboss.com
Tue Jan 30 00:16:20 EST 2007
Enable the SQL log. I'm 99% sure that you simply execute hundreds of SQL queries when the tree is rendered. Read up on explode()/CONNECT BY operators in SQL, and workarounds with "nested set" and "materialized path" (use Google). In Hibernate, you can also think about batch fetching.
Do not optimize or even think about any method call stacks before you optimize the interaction with the database system. If you want to know more about this, specific to Hibernate, read http://www.manning.com/bauer2
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4008130#4008130
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4008130
More information about the jboss-user