I've never seen anything even remotely close to that drastic of a difference. Do you see similar slowness in a non-production application? That would help identify if the issue might be load related or not.
Something a lot of people aren't aware of is start centers utilize MBOs, so if there are java customizations or automation scripts that are firing on initialize they're firing in that scenario too. So especially if you have complex calculations that might work OK when you're looking at 1 or 2 records, they can be a significant bottleneck when running on thousands or more of records. And in those scenarios you may not see long running queries because the bottleneck could be in your code. If your organization primarily use automation scripts to customize and are seeing this in a non-production environment, it might be good to turn on Admin Mode in your non-production environment and see if that improves performance. If it has a drastic impact you will know that it's probably related to one of your scripts. If you have java customizations, admin mode won't help you since all that logic will still execute.
The easiest solution would be if you could deploy an APM (Application Performance Monitor) tool in your environment, especially a non-production environment if you can see it there. Those with the ability to analyze the java code in addition to the SQL statements for a request are especially helpful in identifying where time is being spent in a given request. Sometimes it's a lot of small queries being executed that you aren't seeing that can have a negative impact on performance because collectively it takes a lot of time.
------------------------------
Steven Shull
Director of Development
Projetech Inc
Cincinnati OH
------------------------------
Original Message:
Sent: Fri October 09, 2020 04:40 AM
From: Sreekala R
Subject: Start center performance improvement
Hi Steven,
Thanks for the reply ! We have already created indexes for the table based on the query where clause and performed reorg/runstats too.
We have analyzed the logs and activity dashboard as well to find the long running queries .But we couldn't find long running queries in the logs
We will try ways to optimize the view definition query .We could also observe the time taken for query execution in the data base( a few ms) and the time taken for loading the portlets from front end is different (30s) .Any thoughts on this?
Thanks,
Sreekala R
------------------------------
Sreekala R
Original Message:
Sent: Thu October 08, 2020 08:35 AM
From: Steven Shull
Subject: Start center performance improvement
Most of the time start center performance is entirely impacted by query performance. I would like at your saved queries for your result sets and test them against the database to see what recommendations you might have. Sometimes a new index is required, sometimes adjusting the query, and sometimes it just requires database tuning like updating statistics or rebuilding/reorganizing indexes if they have high fragmentation. You mention that it's fetching from a view, so the issue is potentially with the view definition itself.
I would look at your Maximo logs after loading a start center that takes a while. By default, any query takes longer than 1 second to execute will log to the Maximo logs so you should be able to identify some of your poor performing queries to tune them.
------------------------------
Steven Shull
Director of Development
Projetech Inc
Cincinnati OH
Original Message:
Sent: Wed October 07, 2020 03:26 AM
From: Sreekala R
Subject: Start center performance improvement
Hi All,
May I know the techniques to improve the loading time of Start center portlets which fetches records from views?
Thanks
Sreekala
------------------------------
Sreekala R
------------------------------
#AssetandFacilitiesManagement
#Maximo