Ok... Note that the author had a chat with me about this matter.BTW another time.... ok that you can do it in NH but the real issue is: why Firebird can choose the right plan without an explicit parameter length in the query ? why MsSQL need so complicated clause to simply do the same others RDBMS are doing without any sql clause addition ?
I think that somebody should write to MsSQL team. P.S. I don't remember why the "prepare_sql" property is set to "false" in MsSQL dialect. 2009/3/15 Daniel Auger <[email protected]> > > I apologize that I wasn't clearer in my original post. When I said > that I came across the issue, I meant that I stumbled upon the > original blog post. I am not the author of the blog post, but merely a > C# developer trying to get DBA buy in ;). > > On Mar 15, 4:55 pm, Fabio Maulo <[email protected]> wrote: > > Now I understood who is the author. > > > > 2009/3/15 Daniel Auger <[email protected]> > > > > > > > > > > > > > I'd like to add a little bit of followup on this issue. The original > > > blog author posted a new entry the day after I started this thread. > > > The author indicates that prepare_sql does alleviate the issue. > > > > >http://scarydba.wordpress.com/2009/03/11/a-fix-for-nhibernates-parame. > .. > > > > > In that entry the author points to the following: > > > > >http://testdrivendevelopment.wordpress.com/2009/03/10/nhibernate-quer. > .. > > > > > Also related to this topic: The issue came up right out of the gate on > > > the Herding Code episode 38 podcast that was published on March 13th. > > >http://herdingcode.com/?p=171 > > > > > On Mar 10, 4:30 pm, Daniel Auger <[email protected]> wrote: > > > > So, it looks like the author of the blog post was putting the blame > in > > > > the wrong spot. You are right, the NH team can't fix Sql Server for > > > > MS. > > > > > > Fabio, that request could make for an entertaining conversation. ;) > > > > > > On Mar 10, 3:38 pm, Fabio Maulo <[email protected]> wrote: > > > > > > > Daniel, if you have time please send the same request to the team > are > > > > > developing your RDBMS and ask they why the system is using a > different > > > query > > > > > plan only because a parameter has a different length... at the end > the > > > > > query-plan should be based on tables and fields involved in the > query > > > and > > > > > not on a parameter value especially when the parameter is not > involved > > > in > > > > > the SELECT clause. > > > > > > > 2009/3/10 Daniel Auger <[email protected]> > > > > > > > > Excellent information. Thanks! > > > > > > > > On Mar 10, 2:07 pm, Fabio Maulo <[email protected]> wrote: > > > > > > > try to set prepare_sql to true and, btw, it is a specific > "problem" > > > of a > > > > > > > specific RDBMS. > > > > > > > I know that many people think that NH can solve anything but we > > > can't... > > > > > > > If an RDBMS has a strange way to paginate result, we can do > > > something but > > > > > > we > > > > > > > can't change the RDBMS. > > > > > > > If WCF has a bug for distributed transaction we can apply, may > be, > > > a > > > > > > > workaroud but the bug is in WCF. > > > > > > > If a RDBMS change its behavior when you use "OR" clause instead > > > "IN" and > > > > > > the > > > > > > > "OR" has better performance then "IN" the real problem is not > in NH > > > but > > > > > > in > > > > > > > that RDBMS. > > > > > > > > > We are few, poor and ugly and commercial companies (as > Microsoft or > > > > > > ORACLE) > > > > > > > has more power to fix their issues. > > > > > > > > > 2009/3/10 Daniel Auger <[email protected]> > > > > > > > > > > I hadn't even considered the scariness of that :). > > > > > > > > > > Are you implying this behavior only happens with primary > keys? I > > > was > > > > > > > > under the impression that any of the varchar parameters could > > > > > > > > potentially cause another execution plan to be created. > > > > > > > > > > On Mar 10, 12:35 pm, Gustavo Ringel < > [email protected]> > > > wrote: > > > > > > > > > It is using nvarchar as a primary key, i hope that was what > > > scared > > > > > > you. > > > > > > > > > > > Gustavo. > > > > > > > > > > > On Tue, Mar 10, 2009 at 5:59 PM, Daniel Auger < > > > > > > [email protected] > > > > > > > > >wrote: > > > > > > > > > > > > I came across this today: > > > > > > > > > http://scarydba.wordpress.com/2008/04/29/nhibernate-recompiles-and-ex > > > . > > > > > > > > .. > > > > > > > > > > > > I'm wondering how people are dealing with this, or if it > is > > > seen as > > > > > > a > > > > > > > > > > non issue. > > > > > > > > > -- > > > > > > > Fabio Maulo > > > > > > > -- > > > > > Fabio Maulo > > > > -- > > Fabio Maulo > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
