>Hi Ria
>
>If you can afford to remove the indices before running the process, it would help. However, one often needs indices to check for duplicates.
>
>You can issue a single replace command for a set of fields. There should be little difference.
>
>REPLACE FIELD1 WITH EXPR1, FIELD2 WITH EXPR2
Single Replace command is always faster than multiple REPLACES, especially then record validations are involved...
One of my colleague had multiple replace statements. While browsing his code I noticed it and mentioned in my e-mail. However, he didn't change his code then.
Later this application was turned to my colleague, who followed my original suggestion. The speed improvement was about 5 times...
If it's not broken, fix it until it is.
My Blog