Hello,

having a really slow session.Find() call, I copied/paste the hibernate generated sql to a db client and found out the query is fast !
I debugged the hibernate code and I spend my time in the result set reader.Read(), so in the db driver (oracle).

Why should I experience a difference in the execution time between nhibernate and a sql client ?

thank you

I investigated further and the problem comes from the parameter passing.

If I use the following, this is fast:
Session.Find("select d from ... a where a.Value='"+code+"'");

If I use the following, it's terribly slow:
Session.Find("select d from ... where a.Value=?", code, NHibernateUtil.String);

Is this an oracle driver bug ?

here is the answer:
oracle does not know how to generate a fast plan with a bound variable in that case...