Why? All he has to do is set the correct types.
Also, I correct myself: depending on the way you use the parameters, setting
the type on the mappings might be enough for HQL queries too.
Diego
On Sun, Sep 12, 2010 at 18:11, Fabio Maulo <[email protected]> wrote:
> 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]<nhusers%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/nhusers?hl=en.
>
--
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.
