[jboss-user] [Performance Tuning] - Slow remote database connection

[doktora]

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.

-- Dok

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