Can't you just trust that they removed a couple of these embedded in some loops and that sped things up?
ori 0,0,0
:-)
Coy Krill
Core Processing Team Lead
Washington Trust Bank
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Wednesday, April 24, 2019 11:48
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: 7.4: "In this release, IBM Db2® for i is focused on improving ... performance of SQL as well as ... "
Importance: Low
I was asked about this from my boss. Working closely with him I can guess he’s thinking stuff like:
How did they improve performance of SQL? Did they do something along the lines of:
- SQE vs CQE?
- SQL Plan cache?
- SQL optimizer?
- what?
So I did some research and I find ONE item listed in “Db2 for i - Performance Enhancements”. And that item is: “IASP vary on performance is improved”. Now this may be a big thing for some of you but we really don’t find it applicable to our operations.
Is there something else I am missing in how 7.4 improved the performance of SQL?
Bibliography
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/IBM%20i%207.4%20-%20Base%20Enhancements
https://www-01.ibm.com/common/ssi/ShowDoc.wss?docURL=/common/ssi/rep_ca/4/897/ENUS219-214/index.html&request_locale=en
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
This electronic mail message and any attachments may contain confidential or
privileged information and is intended for use solely by the above-referenced
recipient. Any review, copying, printing, disclosure, distribution, or other use
by any other person or entity is strictly prohibited under applicable law. If
you are not the named recipient, or believe you have received this message in
error, please immediately notify the sender by replying to this message and
delete the copy you received
midrange.com
