Session Evaluation

* There Ain't No Such Thing As a Free Lunch, quote from "The Moon is a harsh Mistress". Choose whatever platform you like, but bad SQL is going to cost dearly.
* KELA "the Social Insurance Institution of Finland" - have some 1½ billion SQLs per day, both CICS/PL1 and Dynamic Java programs.
* A good SQL cost about 0,05 € per 1000 rows fecthed, but bad SQL can be like 1€ per a row read.
* How to manage this challenge? Even a modest effort using KAIZEN methodology have gained some 15 - 20 % reduction in CPU usage.
* Hear what we found out, what we have found in 1 year.