Database performance

nickarls Sep 11, 2007 2:50 AM

Where should I start my hunt for database performance? I'm on JB 4.2.1GA and Seam 2.0.0B1 and I've started converting a Spring app to Seam. I use JPA/Hibernate in both cases but my queries seem to take 2-3 times longer under Seam. I'm sure it is just a tweak, either in Seam or JBoss but where should I start looking?

1. Re: Database performance

christian.bauer Sep 11, 2007 4:31 AM (in response to nickarls)

SQL log
Actions
2. Re: Database performance

nickarls Sep 11, 2007 5:16 AM (in response to nickarls)

"christian.bauer@jboss.com" wrote:
SQL log

Well, the entities are the same and the generated SQL looks the same so I doubt the optimizer would take another path. Are there any switches in Seam/JBoss that might do some extra checking somewhere?
Actions
3. Re: Database performance

nickarls Sep 13, 2007 2:59 AM (in response to nickarls)

The database is the same
The host is the same
The data is the same
The database driver and JPA provider are the same
The entities and resulting SQL is the same

In a standalone tomcat with simlar JVM opts a certain "from Foo" query takes 1,3s but on JBoss it takes closer to 3s. Must check with the performance forum if there are no theories here...
Actions

Go to original post