I certainly will put together a statement or two to MS about this. I am quite astonished that they have not been able to remedy this issue as a fix to SQL 2005. You are right about the hint being an extra somersault that should not be necessary in the first place. Essentially as I understand it, the initial query plan generated is pure bollocks! This is insane that they are taking such a lax approach. Thanks for taking your time to review this. I appreciate your input on this.
Kind regards, John Leger On Mar 15, 5:51 pm, Fabio Maulo <[email protected]> wrote: > Ah, John please don't forget to write something to MsSQL team and ask they > why they need so complicated solution to do the same others RDBMS are doing > without any sql additional clause. > > 2009/3/15 Fabio Maulo <[email protected]> > > > > > MsSQL... MsSQL....pagination issue, special option only to do the right > > thing... I'm something tired. > > BTW yes... the DAL should be aware. > > > 2009/3/15 John Leger <[email protected]> > > >> To the best of my knowledge via searching through this site for > >> support with SQL 2008 dialect I have not seen any plans to support > >> certain new parameterized query options. I was wondering if anyone in > >> the NHibernate community has come across the issue with slow > >> parametrized SQL? I blogged about this recently and essentially the > >> problem boils down to SQL Server doing a real poor job with query plan > >> caching for dynamic parameterized SQL. This issue is now solved with > >> SQL Server 2008. MS recommends adding a query hint using the Option of > >> OPTIMIZE For UNKNOWN. > > >> Reference: > > >>http://blogs.msdn.com/sqlprogrammability/archive/2008/11/26/optimize-... > > >> Is this an issue that an ORM needs to be aware of when supporting a > >> given database dialect? My view is yes. However I am still somewhat of > >> a newb with NHibernate. Appreciate a viewpoint on this. > > >> Thanks > >> JohnL > > > -- > > 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 -~----------~----~----~----~------~----~------~--~---
