Best practices to improve performance in JDBC

• 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