Re: URL Query String Encode and Decode in RPGLE

Hi Stefan,

Yes the JVM has started, I am able to see my job listed under
DSPJVMJOB/WRKJVMJOB.

For the very first time execution, it is taking 9 milliseconds to 10
milliseconds, after this for every following execution it is taking 3
milliseconds to 6 milliseconds.

Regards,
Suren

On Fri, Jun 2, 2023 at 2:17 AM <stefan@xxxxxxxxxx> wrote:

Hi Suren,

exec sql set :EncodedString = SYSTOOLS.URLENCODE(:Input,'UTF-8');
exec sql set :DecodedString = SYSTOOLS.URLDECODE(:Input,'UTF-8');
Could you please guide me to understand why the IBMi-provided function

is taking more time to process? Also, am I missing something in the SQL
statement which is causing the delay?

To my understanding many systools functions are java based - look at the
joblog after running one of these functions and see if a jvm is started.
The overhead is worst at the first call but java is in general slower
anyway.


Regards,

Best regards

Stefan

--
No trees were killed in the sending of this message, but a large number of
electrons were terribly upset.

Stefan Tageson
+46 732 369934
stefan@xxxxxxxxxx


--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.