On Thu, 2002-10-10 at 12:19, Jon Haugsand wrote:
> * Marius Kotsbak
> > Jon Haugsand wrote:
> >
> > >We have a table with approx 1500 rows and a finder that picks one or
> > >two rows during each query like this:
> > >
> > >for (id=0;id++;id<1000) {
> > > // Start transaction
> > > Collection c=findByStatus(id,status);
> > > for(i=c.iterator();i.hasNext();) {
> > > ((EntityLocal) (i.next())) . setStatus(newStatus);
> > > }
> > > // End transaction
> > >}
> > >
> > Why not package the whole in one transaction (including the outher
> > for-statement), too see if this speeds things up, if it doesn't change
> > the semantics of your operation. Or you might start a nested
> > transaction for the inner for.
>
> We can try this in order to see the effect, but we cannot change this
> permanently.
Why not?
>
> --
> Jon Haugsand, <[EMAIL PROTECTED]>
> Norges Bank, <http://www.norges-bank.no>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
--
Marius Kotsbak
Boost Communications A/S
Trondheim, Norway
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
