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-for-unknown-a-little-known-sql-server-2008-feature.aspx > > 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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
