No need to apologize, I've been where you are many times before -- It can be horribly frustrating.
Thanks for your efforts, they are appreciated. Rob On Oct 27, 4:22 pm, Fabio Maulo <[email protected]> wrote: > sorry for the relief... sorry > > 2009/10/27 Fabio Maulo <[email protected]> > > > > > > > and Rob... > > my goal is do the right thing in the right place. > > We all should learn how send issues to MsSQL team and not only looking for > > a workaround in NHibernate. > > Do you have a link to the issue regarding the query-execution plan in MsSQL > > ? > > > do you know why MsSQL need the parameter-size to choose the execution-plan > > ? > > why the others RDBMS does not need it ? > > > why I can write something so simple as > > in FireBird: SELECT FIRST x [SKIP y] rest-of-sql-statement > > in Postgre : SELECT rest-of-sql-statement LIMIT x [OFFSET y] > > in MySQL : SELECT rest-of-sql-statement LIMIT x [, y] > > and in MsSQL I must make me crazy for a simple pagination in the 21th > > century ? > > > why I can't write something like this ? > > SELECT rest-of-sql-statement WHERE CONTAINS(…, …) = :pShouldContain > > Which is the type of return-value of the two functions CONTAINS and > > FREETEXT ? > > > Perhaps you can tolerate all these stuff the MsSQL-team are giving us but > > I'm starting to be a little bit not tolerant. > > > 2009/10/27 Rob <[email protected]> > > >> Although I agree with your sentiment from an architectural perspective > >> (i.e., "ORM is to fill the gap between O and RDMS and not to fix RDBMS > >> issues"), > >> as a practical matter (if NH adoption is your goal), providing the > >> user with a(n easy) way to overcome "issues" is often required by the > >> thing filling the gap. May not be what you'd like to do, but it's > >> often necessary. > > >> Rob > > >> On Oct 27, 10:55 am, Fabio Maulo <[email protected]> wrote: > >> > To be more clearhttp://twitter.com/fabiomaulo/status/5186045199 > > >> > 2009/10/27 Fabio Maulo <[email protected]> > > >> > > if so... remember that the Driver, in NHibernate, is an injectable > >> > > component. > >> > > You can copy&paste the default impl. and then change it to do what you > >> > > want; after that you only need to use the NH's configuration to inject > >> your > >> > > drive. > > >> > > 2009/10/27 Daniel Auger <[email protected]> > > >> > >> The blog author posted a comment on the blog indicating that the team > >> > >> was using NHibernate 2.1.0 with MSSQL Server 2005. I will try to test > >> > >> 2.1.1 when time allows. > > >> > >> Fabio, do the fixes you made negate the need for setting prepare_sql > >> = > >> > >> true? The reason why I ask is that if I'm understanding the blog > >> > >> correctly, using prepare_sql is the wrong way to solve the problem as > >> > >> SQL server is going to cause the execution plan per connection > >> > >> behavior. > > >> > >> On Oct 26, 8:29 pm, Daniel Auger <[email protected]> wrote: > >> > >> > I've sent messages to both the blog poster and the initial reporter > >> to > >> > >> > validate the fix and report back here. > > >> > >> > On Oct 26, 6:13 pm, Fabio Maulo <[email protected]> wrote: > > >> > >> > > Use 2.1.0 and then let me know... > >> > >> > > I don't remember exactly where I have fixed all parameters-size > >> stuff > >> > >> but > >> > >> > > should be 2.1.0 or in the actual branch (2.1.1 that will be > >> released > >> > >> > > on Sundays). > > >> > >> > > 2009/10/26 Craig van Nieuwkerk <[email protected]> > > >> > >> > > > 2.0 it says in the article. Could be 2.01, it is not specific. > > >> > >> > > > On Tue, Oct 27, 2009 at 9:39 AM, Fabio Maulo < > >> [email protected]> > >> > >> wrote: > >> > >> > > > > NH version? > > >> > >> > > > > 2009/10/26 Daniel Auger <[email protected]> > > >> > >> > > > >> This came across my twitter stream today: > > >>http://www.objectreference.net/post/NHibernate-and-Execution-Plans.aspx > > >> > >> > > > >> The blog entry claims that prepare_sql = true really only > >> solves > >> > >> the > >> > >> > > > >> problem on a per connetion basis. > > >> > >> > > -- > >> > >> > > Fabio Maulo > > >> > > -- > >> > > Fabio Maulo > > >> > -- > >> > Fabio Maulo- Hide quoted text - > > >> > - Show quoted text - > > > -- > > Fabio Maulo > > -- > Fabio Maulo- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
