[jboss-user] [Performance Tuning] - Slow remote database connection
do-not-reply at jboss.com
Sun Nov 12 20:10:09 EST 2006
I have always used postgresql on the localhost, which was also running JBoss.
I have moved the DB to a separate computer on the LAN (gigabit), so now JBoss connects via port 5432 (default tcp/ip for postgresql).
It is performing terribly slow when fetching data from the remote DB.
If I connect from the localhost to the remote DB directly via psql -h , I can run the query faster by hand and get the results before JBoss comes around. So I believe the problem is in JBoss/Hibernate and not in my network.
Has anyone experienced this? Where do I begin to look in order to find this bottleneck?
I'm running the following config:
Release ID: JBoss [Zion] 4.0.4.GA (build: CVSTag=JBoss_4_0_4_GA date=200605151000)
Java VM: Java HotSpot(TM) Server VM 1.5.0_06-68,"Apple Computer, Inc."
OS-System: Mac OS X 10.4.8,i386
Postgresql 8.1.5 (built from source)
I'm running a single (non-clustered) instance of JBoss with EJB 3.0.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3985289#3985289
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3985289
More information about the jboss-user