Override the implementation of the Dialect and of the SqlClientDriver and inject your custom implementation through NH's session-factory configuration
On Fri, Sep 10, 2010 at 9:15 AM, Armin Landscheidt <[email protected]>wrote: > Hello I have a little performance problem with NHibernate and our MS- > SQL server. NHibernate creates a sql-statment like: > > exec sp_executesql N' > SELECT this_.Id as Id584_2_, this_.Name as Name584_2_, > ChildChildTable2_.Name as Name638_0_ > FROM MyTable this_ > left outer join ChildTable ChildTable1_ on > this_.Id=ChildTable1_.ParentId > left outer join ChildChildTable ChildChildTable2_ on > ChildTable2_.Id=ChildChildTable2_.ParentId > WHERE this_.Name like @p0 or ChildChildTable2_.Name like @p1; > ',N'@p0 nvarchar(6), @p1 nvarchar(6)',@p0=N'%myname%',@p1=N'%myname%' > > The executiontime is 2 seconds. But if I use varchar for the > parameters the executiontime is 0 seconds. > Has someone an idea what I could do to solve this problem? > > regards > Armin > > -- > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- 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.
