Actually I do not think it is a problem with the queries after working with this a little bit yesterday. It does it with the vanilla Inspections app as well that do not have these queries. I have checked the object structure and aside from these two additional query definitions it looks pretty vanilla. Any way to see what exactly it is downloading that is taking so long?
------------------------------
Christopher Stewart
------------------------------
Original Message:
Sent: Thu May 29, 2025 01:10 AM
From: Juris Flugins
Subject: How to improve performance on mobile query for inspections?
How much inspections do You have per week?
SQL reuslt dosn't look too massive. Maybe You have there lot of attachements, pictures?
------------------------------
Juris Flugins
Expert IT Consultant
TROIA d.o.o
Jurmala
Original Message:
Sent: Wed May 28, 2025 08:05 AM
From: Christopher Stewart
Subject: How to improve performance on mobile query for inspections?
I modified the inspections mobile for Maximo 9 slightly and now when the mobile app updates and hits the inspection app it sits for 10-15 minutes updating inspection data before it continues on. It is the one item that is holding the download up as all othre areas like technician data go through fairly quickly.
I duplicated the inspections app. I then added a couple more datasource overrides as I only want two links in the top dropdown. My completed inspections today and my completed inspections over the past week.
<maximo-datasource-override id="myinspectionstodayds" offline-immediate-download="true" saved-query="INSPRESULTUSERPERDAY"/>
<maximo-datasource-override id="mycompinspectionstodayds" offline-immediate-download="true" saved-query="COMPINSPRESULTUSER"/>
<dropdown hide-unselected-placeholder="true" id="rzvz4" on-change="filterList" selected-item="{page.state.selectedDS}" size="none" slot="dropdown" theme="light">
<dropdown-item id="myInspectionsTodayItem" text="My Inspections Today" value="myinspectionstodayds"/>
<dropdown-item id="myCompInspectionsItem" text="My Completed Today" value="mycompinspectionstodayds"/>
</dropdown>
The queries on the object structure are the following.
COMPINSPRESULTUSER:
createdate >= sysdate - 7 AND status ='COMPLETED' and createdby = :USER
INSPRESULTUSERPERDAY
createdate >= sysdate - 1 and createdby = :USER
Anything I am doing wrong with this that would cause the initial download of the mobile app to stall for this long on inspections? Any recommendations for performance improvement?
------------------------------
Christopher Stewart
------------------------------