I posted a question on 9/27 about overall performance degradation after doing the same upgrade.
Our entire system will randomly slow down to a crawl throughout the day - even simple green screen tasks (like WRKACTJOB).
I have not been able to identify the issue (nor have I opened a ticket).
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rich Marion
Sent: Monday, October 2, 2023 10:45 PM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] V7R5 SQL Engine Performance Issue
I recently upgraded from V7R3 to V7R5 and noticed many of my SQLRPGLE
program are now taking a super long time to complete. The program stack
points to the SQL EXEC or the FETCH statements.
Today, one program was doing a simply "Insert Into" with the "select" having
a "Group By" over a single table (no joins or subqueries). It was supposed
to insert about 1.2 million records into a table that had over 700 million.
I let it run for 3 hours before I canceled it. It was adding about 25
records/second.
I manually executed the same "Select-Group by" and created a table with the
1.2 million records. Then I wrote an Old fashion read/write program via
RLA. This entire process took less than a half an hour.
Has anyone noticed performance issues with the V7R5 SQL Engine?
TIA
Rich
--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
[CAUTION! This email originated outside of the organization. Please do not open attachments or click links from an unknown or suspicious origin.]
midrange.com
