# Use connection pooling. 使用連接池 connection pooling
# Choose appropriate isolation levels. 選擇合適的隔離級別
# Use Statement pooling. 使用statement pooling
# Statements versus Prepared Statements: When to Use What? 合適的選用Statement 或者 PreparedStatement
# Tune the SQL to minimize the data returned (e.g. not ‘SELECT *’). 進(jìn)行SQL調(diào)優(yōu)來減少返回的數(shù)據(jù)集 比如不使用select *
# Avoid the Usage of Metadata Methods (e.g DatabaseMetaData.getColumns() whenever Possible. They are expensive. 盡可能的避免使用Metadata方法(比如DatabaseMetaData.getColumns())
# Try to combine queries and batch updates. 合并查詢和進(jìn)行批量更新
# Use stored procedures.使用存儲過程
# Cache data to avoid repeated queries.對數(shù)據(jù)進(jìn)行緩存來避免重復(fù)查詢
# Close resources (Connections, Statements, ResultSets) when finished with.操作結(jié)束時關(guān)閉資源(連接,statement, ResultSet等等)