Poorly coded programs or improperly coded SQL statements are often the culprit causing poor performance in relational database systems. This presentation’s focus will be to increase JAVA developers’ knowledge in the ways of performance and tuning in an RDMS database environment. I will specifically provide development and SQL tips that improves performance problems that occur in JAVA development. Most of these topics relate to any of the RDMS systems (Oracle, SQL Server, Informix, etc.), but some of the topics slant towards DB2.

For example, today’s developers know that achieving good performance and response times in applications revolves around the tuning of many technical areas. Tuning efforts can be made at the operating system level, the database level, within the network, and in many other system areas. Still, the majority of performance issues among applications that access a relational database are caused by the developers themselves -- by the way they design their programs, and the way they code their SQL queries.

By modifying JAVA and SQL code, understanding Runstat options, and understanding Optimization, there are many things that JAVA developers can do to resolve performance issues. This presentation will provide development tips and suggestions, along with many SQL coding examples, all with the purpose of gaining better performance.

Topic 1 – What causes performance issues?
Topic 2 – Understanding Optimization
Topic 3 – What can a developer get from an Explain Tool?
Topic 4 – Top 25 performance tips for JAVA SQL developers
Topic 5 – Hibernate Performance Concerns

Objectives

• Help JAVA developers understand performance issues
  
• Help JAVA developers understand their roles in performance
  
• Provide JAVA developers with some direction in tuning a poorly performing application, program, or SQL query