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]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
