We are experiencing the similar performance issues... I've built so many indexes since upgrading from v7r3.
At one point it was suggested (IBM) that we add memory, disk controller and disks. This would require a new machine and jumping a processor level.
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Hiebert, Chris
Sent: Tuesday, December 12, 2023 9:45 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: Database / SQL performance question...
Had a similar issue on V7R5 recently.
I had to create an (unique) index over the work table before the DELETE performed as it was on V7R3.
The V7R5 upgrade has been very bad for SQL performance.
--
Chris Hiebert
Senior Programmer/Analyst
Disclaimer: Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of dr2@xxxxxxxx
Sent: Saturday, December 9, 2023 10:09 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Database / SQL performance question...
Greetings,
This week, one of our group had occasion to us SQL to insert a large
number of records into a work file. It was a simple INSERT INTO FROM
WHERE... It went rather quickly.
When he was finished with those records in the work file, he then issues
a simple DELETE FROM WHERE... against his work file. The DELETE took
SUBSTANTIALLY longer than the insert. REUSEDLT isn't an issue and is
off.
It's been a while since I've played in this space, so, I'm curious as to
what, on a MI/DBMS level, is going on that would account for the
substantial time/resource difference.
Thanks
DR2
--
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.
midrange.com
