Re: httpGetBLOB

Do you have a sample of the sql call ? Maybe I am call httpGetBLOB wrong !!

Thanks
John Slanina


-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Henrik
Rützou
Sent: Tuesday, January 16, 2018 12:06 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: httpGetBLOB

PS

And yes, the roundtrip is actually less the 10ms first calculating the no
of rows by running SQL on the table and then formatting the result of each
row in JSON by reading each row in SQL.



On Tue, Jan 16, 2018 at 6:02 PM, Henrik Rützou <hr@xxxxxxxxxxxx> wrote:

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=20180002174252
792


<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&u
tm_campaign=sig-email&utm_content=webmail>
<#m_5494837645365580974_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

--
Regards,
Henrik Rützou

http://powerEXT.org <http://powerext.org/>

--
Regards,
Henrik Rützou

http://powerEXT.org <http://powerext.org/>
--
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