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

2006-11-13 Thread otaylor
What I'd suggest doing is increasing the verbosity of logging from Hibernate to the point you can get it to log the SQL queries it is doing in check to make sure that the *number* of queries it is doing is reasonable. One possible reason that a large query might be slow remotely is that it is

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

2006-11-13 Thread doktora
I think you hit it on the nail. I've looked at the logs and there are a couple of hundred ones, but definitely not thousands, of 1-row queries. Also this issue has gone away with time, without me touching anything. That must be caching in action. I'll investigate further, add laziness and do a