RE: [EXTERNAL] Re: Which one of perform CPU wise. -- RPG400-L

Hi Mohammad,

We use MDRest4i. However, we don’t have many CRUD services, ours are mainly reading data. We also don’t have very high volume like you have. Having said that, now that Scott is working for Midrange Dynamics, I know he is heavily involved with the MDRest4i product. The latest version is basically using his yajl code I think. The main thing I like about the product is that it forces you to create the Swagger document first and then it generates a skeleton program for you based on the definition. That way, you can share your API definition with others via the Swagger document.

Dean Eshleman
Software Development Architect
Everence

1110 North Main Street
PO Box 483
Goshen, IN 46527
(800) 348-7468 ext. 3528
(574) 533-9515 ext. 3528
[Join our Talent Network]<http://www.everence.com/careers>

From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Mohammad Tanveer
Sent: Wednesday, May 3, 2023 10:00 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] Re: Which one of perform CPU wise.

This email originated outside of Everence. Do not click links or attachments unless you recognize the sender.

Anyone using MDREST4i? Our architects are replacing as400 tables with cloud
based tables qnd are asking us to do CRUD operations on them using REST
services. Its becoming a challenge to keep the performance as good
as possible. So performance is the key for us.

On Wed, May 3, 2023 at 6:04 PM Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx<mailto:midrangel@xxxxxxxxxxxxxxxxx>>
wrote:

Strictly from a performance point of view, you “might” get better
performance from the HTTPAPI method, but I doubt it will make much
difference except at extremely heavy loads. Either way you need to keep
things up to date, and with the SQL option, if you run into trouble you can
call IBM. The YAJL method requires the crowd support from forums like this
one, and Scott’s attention.

I guess my take is use the tool you are most familiar with, definitely use
ILE to its full advantage, stored procedures and the like. Use the
performance tools as you are developing to set benchmarks so when you get
to full production you have some idea where things are.

Then there is the work management side of the equation, mostly memory
management. Be sure to use memory storage pools and subsystem definitions
that are built for your environment. IBM’s supplied scheme works, every
time, but it’s not as efficient in all circumstances as it could be. That’s
why they gave use tooling to manage it.

So, it’s IBM’s favorite (and correct) answer: It Depends.

Jim Oberholtzer
Agile Technology Architects

On May 3, 2023, at 12:36 AM, Mohammad Tanveer <surgum@xxxxxxxxx<mailto:surgum@xxxxxxxxx>> wrote:

Anyone recommend which one is better? I feel HTTPAPI is more robust and
does not kill CPU under heavy load hundred of jobs calling rest end

points.

Comparison
HTTPAPI / YAJL
• Easy to use, performs very well
• Full-featured, offers capabilities that none of the others do
• Requires you to download/install 3rd party software

SQL Functions in QSYS2
• Easy to use, performs very well
• Has most needed features; missing multipart; missing error details
• Included with OS, nothing to install -- but need to be up-to-date
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx<mailto:RPG400-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l<https://lists.midrange.com/mailman/listinfo/rpg400-l>
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx<mailto:RPG400-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l<https://archive.midrange.com/rpg400-l>.

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription

related questions.

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

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related
questions.

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

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.

Confidentiality Notice: This information is intended only for the individual or entity named. If you are not the intended recipient, do not use or disclose this information. If you received this e-mail in error, please delete or otherwise destroy it and contact us at (800) 348-7468 so we can take steps to avoid such transmission errors in the future. Thank you.