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-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 > -- 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 -~----------~----~----~----~------~----~------~--~---
