Hi,
I have a procedure that converting characters to others corresponding representation. When I run mytest, It takes 16 secs for 1000 transactions, 8 secs for 500 transactions and 1 secs only for 100 transactions. The result shown seem may not reasonable if compare 500 - 8 secs and 100 - 1 secs.
Why it can happen?
Any mthodology to increase performance of procedure with full with IF and CASE statement (AI)?

Thank you