Re: Which H-specs CTL-OPT do you use?
Patrik Schindler <[email protected]>
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <[email protected]> |
Hello Vern, Am 12.08.2025 um 22:46 schrieb Vern Hamberg via RPG400-L <[email protected]>: > I strongly recommend using Visual Explain tool in ACS. It might show you things you can try to help the performance. The optimizer is sensitive to conditions at the time of running, so environment can affect things > > I'd also check the joblog for any SQLxxxx messages - there shouldn't be any when doing a simple FETCH in a loop, but one never know. Thanks for the hints! :wq! PoC -- This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l. Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.