tomcat-users mailing list archives

On 10/11/2010 09:41, sasidhar prabhakar wrote:
> private static DataSource dataSource;
>=20

Getting the DataSource shouldn't be an expensive operation, so
'optimising' by retaining a static reference to it doesn't make much
sense.

Try just getting a fresh DataSource every time - your DB queries are
taking far longer to process than any theoretical performance
improvement gained here.


p