Re: Escaping strings for JSON (That project involving web services again)

Have you tried using the DB2 JSON publishing functions to build the
(escaped) JSON values?

JSON_Object,
JSON_ArrayAgg

I'm using the DB2 JSON functions to parse incoming JSON strings and build
outgoing JSON strings and it seems to be performing fine for me.

If your requirement (sorry in advance if I'm misunderstanding it) is to
take a single large field in a DB2 table and build a JSON message with some
known key and the (escaped) field value as the er value - it would be just
about no code at all to write a test program to benchmark and see if it
performs better.

You need a pretty current version of the OS and possibly a TR though to get
access to the Publishing Functions.
regards,
Craig


On Mon, 29 Oct 2018 at 18:46, James H. H. Lampert <jamesl@xxxxxxxxxxxxxxxxx>
wrote:

On 10/29/18, 11:11 AM, Sam_L wrote:

FWIW: Consider telling the compiler to optimize, and redo your benchmark.

Back somewhere around 2007 I inherited a program that did extensive
text/string manipulation. It ran slowly, but optimizing made a huge
difference. There is, of course, no guarantee it will help now, but it
doesn't cost much to try.

Compiler optimization does make a difference (37 seconds vs. 195 seconds
for 1000 records, with a per-record range of 2-302 milliseconds, vs.
5-1661 milliseconds), but it's still a disproportionately large amount
of time.

--
JHHL

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD