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

Reply via email to