My mapping is this:
<class name="MasterData">
<id name="Id">
<generator class="identity"/>
</id>
<property name="Version" not-null="true"/>
<property name="Data" not-null="true" type="BinaryBlob"
length="20971520" />
</class>
The time is 15448ms (i.e. ~15 seconds). My regional settings are
Spanish, so the point is the group separator, not the decimal
separator.
And the sql statement being issued by NH (taken from NH log) is:
UPDATE MasterData
SET Version = @p0, Data = @p1
WHERE Id = @p2; @p0= '83a6dcb8-e67d-4df2-b532-ea54c87dbb96', @p1 =
'System.Byte[]', @p2 = '1'
Thanks a lot for your help.
On Wed, Sep 29, 2010 at 5:10 PM, Nexus <[email protected]> wrote:
> Euh i hope you are have an entity(class mapping) mapped around the
> binary array otherwise you still are doing same thing, which is
> updating
>
> Another question can you give me exact statement that is executing
> (TSQL) and is your database on a remote server or somehing and is the
> timing really 15.448 ms better said 15,5 ms ?
>
> regards
>
> On 29 sep, 11:32, Juanma <[email protected]> wrote:
>> That's what I'm doing. I'm just creating a new byte[].
>>
>> Anyway, the problem is not with the dirty check. I've uploaded an
>> snapshot of a dotTrace session (http://twitpic.com/2t0lo5/full). That
>> snapshot is taken after update the varbinary field from 3 bytes to
>> 2MB. As you can see, the most expensive operation is
>> SqlCommand.ExecuteNonQuery. However, the same ExecuteNonQuery in raw
>> sql takes less than a second.
>>
>>
>>
>> On Tue, Sep 28, 2010 at 10:59 AM, Nexus <[email protected]> wrote:
>> > Juanma,
>>
>> > As a general advice don't update blobs think of them as
>> > ValueObjects(DDD). Try removing the binarydocument reference (3bytes
>> > version) and adding another (8MB version), should improve speed
>> > drasticly due to dirty check
>>
>> > --
>> > 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
>> > athttp://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.
>
>
--
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.
