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

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#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...