Re: DataQueue performance jt400Native 10x slower then RPG

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