This discussion is archived
1 Reply Latest reply: May 24, 2013 4:17 AM by Roel RSS

Performance depending on condition expression type

scott.wesley Guru
Currently Being Moderated
Hi all,

I was just wondering what people's thoughts and experiences are regarding performance of conditional expressions.

Tony blogs about it here
http://tonyandrews.blogspot.com.au/2013/04/apex-conditions-and-performance.html

And gives the example
1) Value of item/column in Expression 1 = Expression 2
Expression 1: P1_JOB
Expression 2: SALESMAN

2) PL/SQL Expression

Expression 1: :P1_JOB = ‘SALESMAN’>
Recently I've been trying to eke every shortcut I can with an application and noticed this can be a contributing factor when done dozens of times within a page render.

Cheers,

Scott

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points