× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Here is a link to a simple SQLRPGLE/YAJL program - the time is the
roundtrip on a very small
Power6 server

http://5.103.128.110:6382/pextcgiCOR/demojson2.pgm?pxTS=20180002174252792

<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virusfri.
www.avg.com
<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Tue, Jan 16, 2018 at 5:02 PM, Slanina, John <jslanina@xxxxxxxxxx> wrote:

I tested both

First time called was upward of 15-20 sec. Which makes it unusable for
interactive jobs like customer service staff doing inquiries.
In batched subsequent calls it added about 2 second. So when you do 10000
calls it adds a couples of hours to the job.

John Slanina

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Birgitta Hauser
Sent: Tuesday, January 16, 2018 1:13 AM
To: 'RPG programming on the IBM i (AS/400 and iSeries)'
Subject: RE: Built-in %split RPGLE function - httpFunctions

Did you call the httpGetBLOB multiple times or only a single time.
First call is always slow, but the subsequent calls should run.
A friend of mine writes huge web application (and web-shops) and is using
those httpFunctions without any performance problems.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok) "What is
worse than training your staff and losing them? Not training them and
keeping them!"
"Train people well enough so they can leave, treat them well enough so
they don't want to." (Richard Branson)


-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Slanina, John
Sent: Montag, 15. Januar 2018 21:01
To: 'RPG programming on the IBM i (AS/400 and iSeries)'
<rpg400-l@xxxxxxxxxxxx>
Subject: RE: Built-in %split RPGLE function

I am still gun shy of DB2 SQL functions calls. My last test with
httpGetBlob came back with a respond time that was way to slow when you are
doing thousands of calls.
When we switch to 7.3 this week I want to see if json tables will be
faster than YAJL for parsing.

John Slanina


-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike
Jones
Sent: Monday, January 15, 2018 1:52 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: Built-in %split RPGLE function

IMO...

Whether or not the SQL is faster or slower than RPG depends on what you do
with the parsed results.

If you're going to consume the parsed results in RPG, than an efficiently
written RPG routine would likely perform faster.

If you're going to consume the parsed results in the same SET based SQL
statement, than the SQL would likely perform faster (i.e. the parse
function is called as part of the same SQL query consuming the parsed
results). This would likely result in a smaller volume of code as well,
because SQL is handling all the glue necessary to tie the parse to the
consumption. In RPG, you have to supply said glue code and memory
definition to store the parsed results.

Our shops should have both an RPG and an SQL solution for such a common
thing as parsing a delimited string.

Mike

On Mon, Jan 15, 2018 at 10:23 AM, Jon Paris <jon.paris@xxxxxxxxxxxxxx>
wrote:

Birgitta has supplied an example. Others have mentioned Scott's RPG
Service routines.

Both - I strongly suspect - will be faster than the SQL approach and
certainly easier to understand and modify.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com


--
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
--
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

--
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
--
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





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.