Re: DataQueue performance jt400Native 10x slower then RPG
Niels Liisberg <nli-y1igGha7WhZnI0JKdf8LmQC/[email protected]>
| Newsgroups | gmane.comp.lang.as400.java |
|---|---|
| Message-ID | <CADAk_-iQEmAwUL1xQwUh3uaCej=MkJtWYKOfLGgSGbfxbc0Pow@mail.gmail.com> |
.. 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-y1igGha7WhZnI0JKdf8LmQC/[email protected]> 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 < > [email protected]> wrote: > >> On 4/10/20 11:50 AM, [email protected] 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: [email protected] >> To subscribe, unsubscribe, or change list options, >> visit: https://lists.midrange.com/mailman/listinfo/java400-l >> or email: JAVA400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org >> 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 >> > -- This is the Java Programming on and around the IBM i (JAVA400-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/java400-l or email: JAVA400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org 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