APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Performance depending on condition expression type

Scott WesleyMay 23 2013 — edited May 24 2013

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 21 2013

Added on May 23 2013

#apex, #apex-discussions, #performance

1 comment

396 views