Re: DAO Layer Performance Tuning
From: Anand Stephen (anand_at_sonic.net)
Date: 02/25/04
- Next message: uni: "mysql partial string search"
- Previous message: Lin DeNoyer: "Re: Advice requested regarding Access database in Java"
- In reply to: koluwa: "DAO Layer Performance Tuning"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Wed, 25 Feb 2004 05:03:41 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
- Next message: uni: "mysql partial string search"
- Previous message: Lin DeNoyer: "Re: Advice requested regarding Access database in Java"
- In reply to: koluwa: "DAO Layer Performance Tuning"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
