So the bottom line is ... ? Should I understand it as NH does NOT call this SP, and this is only done by SQL Server, right ?
Kim, sorry but what do you mean by IIRC ? ;) Thanks On 11 mai, 09:45, Kim Johansson <[email protected]> wrote: > 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 > 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.
