Hi!

How can Hibernate be properly configured to obtain the results on a query between 2 datasources in a reasonable time?

It's taking about 1 second to generate the query and 1 second to display 10 results... and think that the whole table has about 11000 lines.

If the query is made between tables from the same datasource, all the 11000 lines are displayed in about 2 seconds.

We are using Spring for session managemet, and we have a session for each database.

Any ideeas to solve the time problem?

Thanks!

For what you say, Hibernate is taking approximately the same time as the database query (which is remarkable, considering that it has to map the resultsets to objects).

-Use the setFirstResult/setMaxResults (pagination) a lot
-Try rethinking your design so that no that many rows are returned in a single trip.
-Use views.
-See if you can create views in one database on tables from the other.
-Use subselect entities with only the fields you need.