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
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