Archive for performance
You are browsing the archives of performance.
Performance tuning tips
Today I will share with you a couple of tips on process performance tuning: rewriting your code to be faster. This, for a change (contrasted with my previous posts on performance tuning), has nothing to do with Oracle or SQL: you can use these tips in any language. When your code has been identified as [...]
Top 10 considerations when preparing a software test plan
Click on images to enlarge -> Test the parts of the application that have changed since the last cycle / go live This part of the test plan is very obvious: test the changes to the application. Each change needs to be tested individually if possible, or as groups if the number of changes is [...]
When NOT to normalise the database
When talking of Database Normalisation, textbooks often talk of BCNF, fifth and higher normal forms. However, in practice (in large software/ERPs) I have rarely noticed normalisation beyond Third Normal form. In fact, there is a certain degree of redundancy that is desirable. While doing database design, I believe there are two critical aspects that should [...]
Performance tuning SQL queries in Oracle
Video tutorial showing how to optimise your SQL queries for maximum performance. Talks about indexes, statistics, hints and optimiser plans.
Using SQL potential
How to use the database SQL to its full potential. The idea is to reduce procedural coding and thereby improve performance, reduce defects.
