Hibernate version:
2.1.6
Mapping documents:
Oracle 9.02

Hi we have big problem with performance in our project. We
make HQL select from one method. This select find one row in rather big table.
I've checked in Oracle trace log that this SQL statement (in the morning I will send how it looks) is very quick but time between startin execution of HQL and geting result is very long (comparing to time needed for SQL select). I wonder where is problem ? I suspect that network communication is slow, but when we make batch insert under Hibernate it works very,very fast.

Program looks like this:

startTx();
for( let say 200 times is exxecuted) {

findProduct(prodName,validFrom,validTill); // here we execute HQL statement
....processing......
}
commit();

Tomorrow I will send more details