- Overview of JDBC
- Choosing the right Driver
- Optimization with Connection
- Set optimal row pre-fetch value
- Use Connection pool
- Control transaction
- Choose optimal isolation level
- Close Connection when finished
- Optimization with Statement
- Choose right Statement interface
- Do batch update
- Do batch retrieval using Statement
- Close Statement when finished
- Optimization with ResultSet
- Do batch retrieval using ResultSet
- Setup proper direction of processing rows
- Use proper getxxx() methods
- Close ResultSet when finished
- Optimization with SQL Query
- Cache the read-only and read-mostly data
- Fetch small amount of data iteratively instead of fetching whole data at once
- Key Points
Monday, April 18, 2005
Best practices to improve performance in JDBC
Subscribe to:
Post Comments (Atom)
Popular Posts
- as400 Iseries Tips
- Creating an as400 Query
- Contact Us
- What is QZHQSSRV job?
- Ten CSS tricks you may not know : evolt.org, Code
- Daniel Dan Carter Beard's Outdoor Handy Book or American Boy's Book of Sport - October 15, 1896
- QUSRJOBI API (Retrieve Job Information) as400
- iReport - OpenSource Java Reporting Tool
- AS400 APIs
- Using QCLRDTAQ to clear data queues in CL and RPG
No comments:
Post a Comment