[jboss-user] [JBoss Seam] - Re: Seam + EJB3 performanceL

christian.bauer@jboss.com 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 mailing list