There can be multple reasons for a system to be slow.
A good starting point is to set your SQL logger to WARN and then look for Slow SQL warnings e.g. BMXAA6720W warnings.
I discuss this error message and how to interpret it here:
http://www.linkedin.com/pulse/individual-bmxaa6720w-slow-sql-entries-maximo-logs-need-mark-robbins
Optimising the SQL highlighted in those warnings often delivers significant benefits.
Cohesive can offer a full log analysis to help identify the cause of these problems and help optimise a system. Feel free to reply to me privately and I can put you in contact with our sales team
------------------------------
mark robbins
Cohesive
IBM Champion 2017-2023 Inclusive
See my blog on Maximo support related topics here:
https://www.linkedin.com/pulse/maximo-support-advice-from-non-ibm-engineer-article-mark-robbins/------------------------------