Refactoring SQL Applications
“The application design is the most important factor in performance”
In RSA, Stephane Faroult, lays out examples of Java code, user defined functions and views and how a coders notions of modular procedural programing and/or object instantiation can run undermine database performance from cookie cutter reuse of code to table joins written in Java. If you’ve ever seen Tom Kyte’s “Developer Super Session – The Best Way”, then you know the best way is not to do it and his example is of a coders doing “count(*)” to find out how many loops to do or how big an array to layout. Tom explains the disasters this can create and how the best way is just to not do the count(*) and how this works by letting the database do the work. Letting the database do the work is explained clearly and with many examples from different perspectives in “Refactoring SQL Applications”.