>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
John,
You don't provide much information here. I suspect that somewhere between 100 and 500 transactions you hit the memory limit and VFP swaps some temporary information do disk instead of doing its business in RAM.
José