| By Dave Beulke, on January 22nd, 2013 While doing DB2 performance reviews for clients over the years, I’ve discovered that many times their projects are using Hibernate as their DB2 Object Relational Mapping (ORM) interface. While DB2 and Hibernate can produce tremendous performance there are many best practices to achieve that goal. The following DB2 Hibernate performance improvement techniques will help your . . . → Read More: DB2 Hibernate Performance Improvements By Dave Beulke, on January 15th, 2013 As your Java workload continues to grow, your application monitoring and SQL performance needs to be improved within the system and application coding. The following techniques will help you monitor, improve and streamline your DB2 Java application performance. First, know your application connections and threads. When doing performance reviews of a client’s DB2 applications, it’s . . . → Read More: DB2 Java Application Performance: Monitoring and SQL Improvements By Dave Beulke, on November 13th, 2012 One of the presentations that I did at the IDUG Berlin conference was “Java DB2 Developer Performance Best Practices.” This speech covers all the interesting Java application designs, coding consideration and database related best practices I have found over the years doing application performance tuning for a wide range of industries. Interestingly the main questions . . . → Read More: Java Database Exception Handling By Dave Beulke, on May 13th, 2009 Another situation when a transaction runs into problems is when it must check something outside of the critical transaction path or its normal activity. For example, when a transaction uses seven different discrete web services to accomplish a complete transaction unit-of-work and after the third web service runs into a situation where something else needs . . . → Read More: DB2 Java Performance Standalone Transactions Part 2 By Dave Beulke, on May 6th, 2009 In previous blog entries I have talked about transaction scope, how DB2 Java applications access the database too much and transaction units of work (UOWs) are not really analyzed properly. Too often these days the design and development are done in an Agile or SCRUM type of project methodology where short concise project deliverables are . . . → Read More: DB2 Java Performance Standalone Transactions Part 1 By Dave Beulke, on April 29th, 2009 DB2 Java performance is often a problem because the application processing is emulating the database which executes more efficiently or the processing is poorly designed. Either of these scenarios that my teams have found during performance or design reviews always led to extended I/O activities and excessive CPU usage. Too often, when the application was . . . → Read More: Design DB2 Performance into Your DB2 Java Transactions By Dave Beulke, on April 8th, 2009 Designing the Unit-of-Work for a given transaction entails many components. Different techniques and methods are incorporated depending on the components such as Hibernate, iBatis, JPA or Enterprise Bean technology to process the transaction. The Java transaction framework and the object patterns incorporated with the components also affect the transaction unit-of-work. All these factors together provide . . . → Read More: DB2 Java Performance: DB2 Design UOW By Dave Beulke, on April 1st, 2009 Control DB2 Java Application References to the DatabaseOne of the first standards and principles neglected in the DB2 Java applications that I have seen is that the application references the database too many times to complete a single transaction. While it is good to use your ORM database interface, the architect and application programmer . . . → Read More: DB2 Java Performance: DB2 Transaction Framework (cont.) By Dave Beulke, on March 25th, 2009 Given the object model of Java and the relational model of the database, accessing data properly continues to be difficult for most Java application developers. Over the history of Java development, there have been many attempts within vendor products, interfaces and open source projects to bridge this object to relational data chasm. Many object to . . . → Read More: DB2 Java Performance: DB2 Transaction Framework By Dave Beulke, on March 18th, 2009 Over the last three years, my clients have shown that multiple frameworks, architectures and programming patterns are usually implemented within the same project. The problem is the poor performance lessons experienced from the application implementation are not fully understood and the performance problems are continued and replicated into the next architecture, framework or pattern. Each . . . → Read More: DB2 Performance is Java Performance: Holy Grail (cont.) | |