1 Reply Latest reply: May 24, 2013 6:17 AM by Roel Hartman RSS

    Performance depending on condition expression type

    scott.wesley
      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