are you runing this command on a session per request? what is the transaction scope ?
2010/8/31 Craig van Nieuwkerk <[email protected]> > 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]<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]<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]<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.
