Answered Performance issue with use of -cpinternal UTF-8 startup parameter

[Ranjith0705]

Hi Guys,

I try to read a pdf file, encode it and split the data into a specified length and write it back to a text file. When the session is started with -cpinternal is "UTF-8" it takes more time to execute than when -cpinternal is "ISO8859-1". I have attached the code which i am running for reference. It is taking more time in performing the arithmetic operation in the substring function.

Any suggestions on why it takes more time with UTF-8.

Thanks in Advance.

 

[Jean-Christophe Cardot]

Hi
Does this help to do
FIX-CODEPAGE ( EncodedData) = "ISO8859-1".
before anything else?
Base64 encoded fits in ISO8859-1 so this could work.
Regards
JC

 

[Stefan]

As to the why:

google site:progress.com utf-8 performance longchar

INDEX and SUBSTRING functions are slow with UTF-8 client

So yes, Jean-Christophe's solution should work.

 

[Ranjith0705]

Thanks Jean and Stefan, it is working