Whoever told you that is probably confusing the statement (true) that "NH generates parameterized SQL statements" with "NH generated sprocs" (not true).
Among other things, parameterized SQL statements permit modern DB engines (like MS SQL Server and many others) to cache the query plan for the statement. This means that the the DB only needs to generate a query plan ONCE for each NH query (the first time each query is executed). Since pre-calculated query plans are often the primary source of perceived performance gains from using sprocs, this specific advantage of sprocs is mitigated by NH generating parameterized SQL queries. In this manner, much of the performance benefit of sprocs is also achieved by NH and this is (my guess) the origin of the statement to which you are referring. -Steve B. On May 10, 11:24 am, graphicsxp <[email protected]> wrote: > Hi, > > I was told that when using NH along with SQL Server, the generated SQL > was always embeded within a stored procedure. Is this true ? And if > so, which one ? > I've always thought the SQL was generated and then executed right > away.... > > Thanks > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group > athttp://groups.google.com/group/nhusers?hl=en. -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
