Hibernate version: 2.1

I have an application that is accessing a database that is across the country. So there is some network latency. When the database and the client are colocated (same coast) the application saves a large object model in 2-3 seconds. When the database is across the country it is more like a minute. Does anyone know how to improve performance while sticking to version 2.1. I spent a week trying to upgrade to 3.1 and never got past a "tupple" error.

Thanks,
Dan

Are you using caching? Have you enabled SQL logging to see the SQL that is being executed?

I haven't tried caching yet. When I look at the log it appears that there is a call for each update and insert. So there just a lot of calls back and forth (the network admin confirmed this as well). There isn't a lot of quering of tables that are static. Is there a caching approach that might limit the number of calls?

Thanks,
Dan

Have you experimented with the hibernate.jdbc.batch_size property?

I did try setting batch size but still didn't see an improvement.

You need to have a very close look at your queries and application flow. Once you have that in check then you can rework you data management. Its likely there are a few areas that you can get immediate benefit but this is generally a difficult (and potentially long) process.