Re: DataQueue performance jt400Native 10x slower then RPG

.. Another thing that crossed my mind:

Since jtOpen (jt400) has no idea of what size of data you are working with
- my guess is they will transport the max size always for implementing a
simpler transportations layer ... So maybe if you get closer to the max 64K
the difference will level out. You know the saying: Performance issues are
not performance issues until they become performance issues..

So maybe - my previous post will only work if you cast the data size to the
9K you are using - for the same reason as above.

.. Does it make sense?





On Fri, Apr 10, 2020 at 11:48 PM Niels Liisberg <nli@xxxxxxxxxxxxxxxxx>
wrote:

Maybe just for having the bigger picture: Have you tried you use a simple
select from the dataqueue service from jdbc:

Like:
Select * from table(qsys2.QSYS2.RECEIVE_DATA_QUEUE()...

The reason why I suggest that is that Db2 uses ILE under the covers (I
guess) to read the queue - and maybe that will give you the extra
performance ...

.. I am just guessing .... Just try to get your performance back with
straight jtOpen and JDBC



https://www.ibm.com/support/pages/node/1136812

On Fri, Apr 10, 2020 at 8:41 PM David Gibbs via JAVA400-L <
java400-l@xxxxxxxxxxxxxxxxxx> wrote:

On 4/10/20 11:50 AM, Franz.Rauscher@xxxxxxxxxxx wrote:

On a Workstaion it performan much much mor worst

But thats clear to me becuase all traffic goes over Network.

Do you have any 3rd party security exit programs installed?

In the past, I've seen performance issues with Java interactions when
exit
programs are involved.

david

--
IBM i on Power Systems: For when you can't afford to be out of business!

I'm riding in the American Diabetes Association's Tour de Cure to raise
money
for diabetes research, education, advocacy, and awareness. You can make
a
tax-deductible donation to my ride by visiting
https://mideml.diabetessucks.net.

You can see where my donations come from by visiting my interactive
donation map
... https://mideml.diabetessucks.net/map (it's a geeky thing).

I may have diabetes, but diabetes doesn't have me!
--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing
list
To post a message email: JAVA400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com