My guess ... a temporary index (MTI) is created.
And as soon as you run an IPL all MTIs disappear, so with the next run of
the program the temporary index is created again.
Check whether a temporary index is used and create a permanent index
instead.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rena
Winton
Sent: Dienstag, 15. Dezember 2020 19:16
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: After V7R4 Embedded Sql performance issue
Has anyone has this issue after upgrading to V7R4:
RPG program with embedded SQL, Cursor open then Fetch from that cursor....
program runs fine for several days, then sporadically will run extremely
slow. Seems to be stuck on the SQL_Fetch statement.... program is running
and updating rows. Normal run time is 15 mins.... slowup can be 24 HRS
plus.
Has something changed with SQL Engine or somewhere else with the upgrade?
Rena Winton
Bus Intelligence Developer III
Application Development
NYCM Insurance
1899 Central Plaza East
Edmeston, NY 13335
Phone:
(607) 965-7055
nycm.com
Join us on Facebook at www.facebook.com/NYCMInsurance.
***CONFIDENTIALITY NOTICE***
This email and any attachments to it are confidential and intended solely
for the individual or entity to whom it is addressed. Any unauthorized
review, use, disclosure or distribution is prohibited. If you have received
this email in error, please contact the sender by reply email and destroy
all copies of the original message.
--
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.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
