Hi John,
You can increase the speed of IF & DO CASE by listing the most likely condition first.
>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
kenweber
GCom2 Solutions
Microsoft Certified Professional