+1 On Sun, Mar 15, 2009 at 11: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-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 -~----------~----~----~----~------~----~------~--~---
