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