Re: [Springframework-developer] Commons Pooling and DBCP

[Rod J. <rod...@in...>]

With Oracle an optimization I've committed today to only call
setAutoCommit() if it needs to restored to true should give another 10%
improvement in performance of the DataSourceTransactionManager.
setAutoCommit() is a very expensive operation on an Oracle connection. Don't
know about other databases, but I wouldn't be surprised if they're similar.

Regards,
Rod

----- Original Message ----- 
From: "Trevor Cook" <pr...@se...>
To: <spr...@li...>
Sent: Thursday, November 27, 2003 2:35 PM
Subject: RE: [Springframework-developer] Commons Pooling and DBCP


> We don't do heavy benchmarking, but our early tests showed about 15% gains
> (but this wasn't white paper benchmarking, this was just running our
> client's project tests). BTW, we use postgres 7.3
>
> Speed wasn't actually the reason we switched though.  We had a really
weird
> (as in unreproducable) bug that cropped up every 2 weeks and crashed the
> connection which is why we updated.  Since the update the problem has
> disappeared (4 weeks, no crash :) ).
>
> Trevor
>
>
> -----Original Message-----
> From: spr...@li...
> [mailto:spr...@li...]On Behalf
> Of Rod Johnson
> Sent: November 27, 2003 9:16 AM
> To: spr...@li...
> Subject: Re: [Springframework-developer] Commons Pooling and DBCP
>
>
> Trevor,
>
> Have you found significant benefits? I've seen +30% in a benchmark due to
> adding prepared statement caching.
>
> Regards,
> Rod
>
> ----- Original Message -----
> From: "Trevor Cook" <pr...@se...>
> To: <spr...@li...>
> Sent: Thursday, November 27, 2003 2:05 PM
> Subject: RE: [Springframework-developer] Commons Pooling and DBCP
>
>
> > +1 (we're already using it)
> >
> > Trevor
> >
> > -----Original Message-----
> > From: spr...@li...
> > [mailto:spr...@li...]On Behalf
> > Of Rod Johnson
> > Sent: November 27, 2003 8:09 AM
> > To: spr...@li...
> > Subject: [Springframework-developer] Commons Pooling and DBCP
> >
> >
> > Anyone object if I upgrade the versions in CVS to 1.1 for each? DBCP 1.1
> > certainly performs better.
> >
> > Regards,
> > Rod
> >
> > ____________________________________________________
> > Rod Johnson
> > J2EE Consultant and Author
> > +44 7973 409 132
> > rod...@in...
> >
> > Author of "Expert One-on-One J2EE Design and Development"
> > (October 2002).
> > http://www.amazon.com/exec/obidos/tg/detail/-/0764543857/
> >
> > Founder, Spring Framework:
> > http://www.springframework.org
> >
> > "Introducing the Spring Framework" (ServerSide article)
> > http://www.theserverside.com/resources/article.jsp?l=SpringFramework
> >
> >
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by: SF.net Giveback Program.
> > Does SourceForge.net help you be more productive?  Does it
> > help you create better code?  SHARE THE LOVE, and help us help
> > YOU!  Click Here: http://sourceforge.net/donate/
> > _______________________________________________
> > Springframework-developer mailing list
> > Spr...@li...
> > https://lists.sourceforge.net/lists/listinfo/springframework-developer
> >
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by: SF.net Giveback Program.
> > Does SourceForge.net help you be more productive?  Does it
> > help you create better code?  SHARE THE LOVE, and help us help
> > YOU!  Click Here: http://sourceforge.net/donate/
> > _______________________________________________
> > Springframework-developer mailing list
> > Spr...@li...
> > https://lists.sourceforge.net/lists/listinfo/springframework-developer
> >
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?  SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?  SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer