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



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.