Yes, that is what I do already, but still have locking issues when a
large number of updates are issued.

On Wed, Sep 1, 2010 at 12:18 PM, José F. Romaniello
<[email protected]> wrote:
> what about using an executable hql;
> s.CreateQuery("update Banners b set b.ImpressionsCount = b.ImpressionsCount
> +1 where b.Id = ?").SetParameter(id).ExecuteUpdate()
> 2010/8/31 Craig van Nieuwkerk <[email protected]>
>>
>> Hello
>>
>> I have a web site and on it is an advertising banner (or multiple).
>> Every time this banner is displayed I want to increment an Impressions
>> field in a table. In a day there could be potentially 100k+ updates to
>> this table and I have experienced locking issues on the table. To
>> resolve this up until now I have just queued the updates so they
>> happen synchronously. Is there a better way to do this when using
>> nHibernate?
>>
>> Craig.
>>
>> --
>> 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.
>

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

Reply via email to