Ah, that's the exec_sql() SP thing, that's a SQL Server thing, not NH if IIRC.
Med vänliga hälsningar, Kim Johansson Industritorget Sweden AB Söndrumsvägen 29 302 39 Halmstad tel: 035 - 260 32 00 fax: 035 - 12 24 83 epost: [email protected] webb: http://www.industritorget.se -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of graphicsxp Sent: den 11 maj 2010 09:07 To: nhusers Subject: [nhusers] Re: What does NH in the background ? A colleague of mine told me that he once used the SQL Server profiler to see what SQL was generated by NH. He saw that the SQL was embedded within a SP. Honnestly I found it strange too, so I just wanted to double check with other people. Thanks ! On 11 mai, 02:25, sbohlen <[email protected]> wrote: > 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 > 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. -- 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.
