Re: Which one of perform CPU wise.

I did some testing using QSYS2 http functions. I selected only http header
in my sql which tells me that http request status is success or fail. Using
iDoctor report I see CPU usage is almost nothing. But with response
message CPU usage goes up. Which makes me believe that getting response
message from http call is CPU intensive operation. Response can be large
clob field. Same test with http_req CPU usage was relatively higher
compare to QSYS2 functions.

On Thu, May 4, 2023 at 9:11 AM Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>
wrote:

I'm one of the developers of MDREST4i... the new version that will be
coming out in a few months will definitely outperform the current
version... but it's a really powerful tool, makes the work a lot easier
for you, you don't have to code everything by hand. (as you do with my
other tool, HTTPAPI.)

Obviously, there are a lot of factors in the performance of everything.
Network speed, server speed, etc... and a REST method will never be as
fast as straight disk access. But the design of the API also makes a
huge difference... it's much more performant for an API to work with a
batch of data so that there are fewer calls vs. smaller data and lots
more calls, for example.

Just my thoughts.

On 5/3/2023 8:59 AM, Mohammad Tanveer wrote:

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.

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

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.