PL/SQL performance freak series – alternatives to PL/SQL function calls from SQL Last week I revealed the numbers standing behind the overhead of calling a Pl/SQL function from within an SQL statement. I’ve left two questions open: – Is it always a performance issue, when you call a PL/SQL function from a SQL statement? – What can be done to maintain the function encapsulation (have the code DRY) and… Read More
PL/SQL performance freak series – function calls from SQL overhead In my previous post I’ve shown and measured the performance loss on passing the parameters to and from procedure/function call inside PL/SQL code. In this article I’m about to reveal another bottleneck that is often forgotten and not so easy to overcome. Suppose you need to have some value calculated. The formula is straight matematical calculation but the… Read More
PL/SQL performance freak series – function/procedure parameters overhead When writing a PL/SQL code, I usually use following strategy: If the code that I’m calling is returning a calculated value, it should be a function. If the code that I’m calling is doing some DB operations and is not returning a value, it should be a procedure. There are however some situations, when I tend to… Read More