DAO Layer Performance Tuning

Thread view:

koluwa - 20 Feb 2004 13:22 GMT

Hi all,

Does anyone know of any articles, which describes DAO layer performance
tuning? I'm having some performance issues with data access through this
layer. Some advice on DOs and DON'Ts are welsome.

Thanks in advance,
koluwa

Reply to this Message

Anand Stephen - 25 Feb 2004 05:03 GMT

> Does anyone know of any articles, which describes DAO layer performance
> tuning? I'm having some performance issues with data access through this
> layer. Some advice on DOs and DON'Ts are welsome.

DOs
The two most straight forward ones...
* use connection pool
* use prepared statements.

DOs
Depending on what spec of JDBC your driver supports:
if JDBC 2.0
* use batch updates.
DONT's

* dont close the connection, return it to the pool.

Hope this helps,
Sorry if the answers where too basic.
--a

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...