IIRC = If I Recall/Remember Correctly Yes, NH doesn't explicitly call this SP, it's something SQL Server do, it's done for Entity Framework and LINQ to SQL as well sometimes.
It's nothing to worry and carry about... That's just the way it is. 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 11:02 To: nhusers Subject: [nhusers] Re: What does NH in the background ? 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. -- 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.
