Re: Powerlink Performance Tuning

Wil,

do you have bad performance for all kind of transactions of PowerLink? Or maybe some particular views or transactions are slow?

My experience is that database access can make the fastest machines very slow. The advantage of PowerLink is the flexibility to change views, cards, sorts and subsets. Sometimes this turns into a disadvantage if the generated SQL takes too much time. For this Infor has build the Debug-Options in PowerLink. This is a easy way to find and fix bottlenecks in the database access.

If there is only a problem in particular situations and you are able to reproduce this scenario it would be a good idea to run the PowerLink-Client in Debug-Mode to trace the DatabaseConnection. 

If you cannot reproduce the problem the Index Advisor (see IBM i Navigator) would be the best way to find problems. Take a look at the recommended indexes for your AMFLIBx and AMCESSQL. Some of our customers had a bad performance with new machines and new client hardware. Building the cards took a few seconds each time. We found that there were temporary indexes build to access data each time the opened a particular view or card. We could analyze these activities and created own indexes (SQL: CREATE INDEX…) and then the system was very fast. 

If you need some more information about DebugMode and/or IndexAdvisor please let me know.

And: what is your PCM-level? Infor provided some PTFs to get better performance. See inforXtreme KnowledgeBase. Maybe this will help you.

-- 

Mit freundlichen Grüßen/Best regards
Michael Raber

-------------------------------------------------------
Dipl.-Ing. Michael J. Raber
Consulting - Projectmanagement - Software-Engineering

Villar-Perosa-Straße 10
75038 Oberderdingen

Tel:   +49 7045 2006880
Fax:   +49 7045 2006881
Mobil: +49 1520 8523330

eMail: [email protected]
Web:   www.mjraber.de
Skype: mjraber

Am 09.05.2014 um 18:09 schrieb Ramos, Wil <WRamos-zSmIeidqU5NWk0Htik3J/[email protected]>:

> Does anybody have any tips and tricks on how to improve Powerlink R9 response time?  We recently upgraded to Windows 7 Enterprise 64-bit running on 8GB, 1600mhz computers.    There were very slight improvements but not much to my expectations.
> 
> Any ideas?
> 
> 
> This email and any attachments may contain confidential and proprietary information and must be treated as such.  In addition, export or re-export of the information contained in or attached to this email may be prohibited under export control laws.
> 
> -- 
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/mapics-l.
> 

-- 
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.