ok... the update is about recalculate something or you need to assign values from another source ?
2010/3/12 Billy Stack <[email protected]> > In relation to cascades, it does not need to update any other entity/table. > The update involves just updating records only, no insertions! > > On Fri, Mar 12, 2010 at 3:40 PM, Fabio Maulo <[email protected]> wrote: > > A little description of the characteristic of entities you need to update > ? > > - ok for ID > > - soft cascades ? > > - the update involve few properties updates or even inserts/deletes ? > > > > 2010/3/12 Billy Stack <[email protected]> > >> > >> All, > >> > >> We seem to be having a delay problem when we attempt to update 500+ > >> entities to the database during a single session flush. > >> The session still ends up updating the database correctly, but it > >> takes a few minutes to do so. > >> > >> We traced the session and we have narrowed down the problem i.e. see > >> the following trace lines which have been extracted from the log file: > >> > >> 2010-03-12 14:17:35,046 INFO SELECT ... > >> 2010-03-12 14:17:35,171 DEBUG Hydrating entity: starts > >> 2010-03-12 14:17:35,373 DEBUG done processing result set (592 rows) > >> 2010-03-12 14:17:35,389 DEBUG resolving associations for > >> 2010-03-12 14:17:35,545 DEBUG aggressively releasing database connection > >> 2010-03-12 14:19:09,558 DEBUG flushing session > >> 2010-03-12 14:19:09,558 DEBUG dirty checking collections > >> 2010-03-12 14:19:09,636 DEBUG Flushed: 0 insertions, 592 updates, 0 > >> deletions to 593 objects > >> 2010-03-12 14:19:09,667 DEBUG executing flush > >> <<592 Updates performed in here>> > >> 2010-03-12 14:19:12,193 DEBUG post flush > >> 2010-03-12 14:19:12,193 DEBUG closing session > >> 2010-03-12 14:19:12,193 DEBUG running BatcherImpl.Dispose(true) > >> > >> Note that it takes over 90 seconds between these two lines: > >> 2010-03-12 14:17:35,545 DEBUG aggressively releasing database connection > >> 2010-03-12 14:19:09,558 DEBUG flushing session > >> > >> We have implemented our own unit of work implementation where we: > >> > >> Create a session via the session factory > >> (this.c_sessionFactory.OpenSession()) > >> Session.Flush(); > >> Session.Close(); > >> > >> Note that we do not use session transactions as the table that is > >> updated cannot be locked for a long time, so instead we are using the > >> session.flush() default behaviour. > >> > >> On a last point of note, the entity has an Id that is "assigned". > >> > >> Anybody now what the problem is - or any pointers in the right > direction? > >> > >> Cheers, > >> Billy > >> > >> -- > >> 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]<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]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
