https://community.esri.com/t5/developers-questions/how-can-i-improve-performance-of-this-arcade-data/m-p/1353168#M6835 <P>Hey all,</P><P>Posting this here to see if anyone can help improve the performance of an Arcade script I'm using. The script is essentially a join between a spatial layer and a related table and is used as a data expression in a dashboard.</P><P>Though this is currently achieved via a joined view layer, that restricts schema edits to the hosted feature layer and I'm hoping to get away from that. Additionally, another use case I have joins three related tables which you can't do with a joined view layer.</P><P>In the simpler case of joining one related table, the base of the script I got was from this <A href="https://github.com/Esri/arcade-expressions/blob/master/dashboard_data/JoinLayerFieldsToTable.md" target="_self">github page</A> (and pasted below). The only minor change I made was to specify fields for the feature sets as opposed to returning all fields.</P><P>If I use that data expression as a source for a dashboard item (e.g,. an indicator), load times are around 75 seconds vs. 3-5 seconds though a joined view layer.</P><P>Is there anyway to improve performance of this script? It would help immensely. My other use case where I join three related tables currently takes around 2.5 minutes to load. Though it works as expected, the load times are brutal.</P><P>Any help is greatly appreciated! Thanks all.</P><LI-CODE lang="javascript">var portal = Portal("https://www.arcgis.com/"); var polyfs = FeatureSetByPortalItem( portal, "4dbbad3d6f694e0ebc7c3b4132ea34df", 0, ["*"], false ); var tablefs = FeatureSetByPortalItem( portal, "4dbbad3d6f694e0ebc7c3b4132ea34df", 6, ["*"], false ); // Create empty features array and feat object var features = []; var feat; // Populate Feature Array for (var t in tablefs) { var tableID = t["FeatureID"] for (var p in Filter(polyfs, "HydroID = "+tableID)){ feat = { attributes: { FeatureID: tableID, Name: p["DPS_Region"], ModelID: t["ModelID"], AddressCount: t["AddressCount"], MAX_TSTime: t["MAX_TSTime"], } } Push(features, feat) } } var joinedDict = { fields: [ { name: "FeatureID", type: "esriFieldTypeString" }, { name: "Name", type: "esriFieldTypeString" }, { name: "ModelID", type: "esriFieldTypeInteger" }, { name: "AddressCount", type: "esriFieldTypeInteger" }, { name: "MAX_TSTime", type: "esriFieldTypeString" }, ], 'geometryType': '', 'features':features }; // Return dictionary cast as a feature set return FeatureSet(joinedDict);</LI-CODE><P>&nbsp;</P> Fri, 24 Nov 2023 15:15:33 GMT Vinzafy 2023-11-24T15:15:33Z https://community.esri.com/t5/developers-questions/how-can-i-improve-performance-of-this-arcade-data/m-p/1353168#M6835 <P>Hey all,</P><P>Posting this here to see if anyone can help improve the performance of an Arcade script I'm using. The script is essentially a join between a spatial layer and a related table and is used as a data expression in a dashboard.</P><P>Though this is currently achieved via a joined view layer, that restricts schema edits to the hosted feature layer and I'm hoping to get away from that. Additionally, another use case I have joins three related tables which you can't do with a joined view layer.</P><P>In the simpler case of joining one related table, the base of the script I got was from this <A href="https://github.com/Esri/arcade-expressions/blob/master/dashboard_data/JoinLayerFieldsToTable.md" target="_self">github page</A> (and pasted below). The only minor change I made was to specify fields for the feature sets as opposed to returning all fields.</P><P>If I use that data expression as a source for a dashboard item (e.g,. an indicator), load times are around 75 seconds vs. 3-5 seconds though a joined view layer.</P><P>Is there anyway to improve performance of this script? It would help immensely. My other use case where I join three related tables currently takes around 2.5 minutes to load. Though it works as expected, the load times are brutal.</P><P>Any help is greatly appreciated! Thanks all.</P><LI-CODE lang="javascript">var portal = Portal("https://www.arcgis.com/"); var polyfs = FeatureSetByPortalItem( portal, "4dbbad3d6f694e0ebc7c3b4132ea34df", 0, ["*"], false ); var tablefs = FeatureSetByPortalItem( portal, "4dbbad3d6f694e0ebc7c3b4132ea34df", 6, ["*"], false ); // Create empty features array and feat object var features = []; var feat; // Populate Feature Array for (var t in tablefs) { var tableID = t["FeatureID"] for (var p in Filter(polyfs, "HydroID = "+tableID)){ feat = { attributes: { FeatureID: tableID, Name: p["DPS_Region"], ModelID: t["ModelID"], AddressCount: t["AddressCount"], MAX_TSTime: t["MAX_TSTime"], } } Push(features, feat) } } var joinedDict = { fields: [ { name: "FeatureID", type: "esriFieldTypeString" }, { name: "Name", type: "esriFieldTypeString" }, { name: "ModelID", type: "esriFieldTypeInteger" }, { name: "AddressCount", type: "esriFieldTypeInteger" }, { name: "MAX_TSTime", type: "esriFieldTypeString" }, ], 'geometryType': '', 'features':features }; // Return dictionary cast as a feature set return FeatureSet(joinedDict);</LI-CODE><P>&nbsp;</P> Fri, 24 Nov 2023 15:15:33 GMT https://community.esri.com/t5/developers-questions/how-can-i-improve-performance-of-this-arcade-data/m-p/1353168#M6835 Vinzafy 2023-11-24T15:15:33Z https://community.esri.com/t5/developers-questions/how-can-i-improve-performance-of-this-arcade-data/m-p/1353316#M6836 <P><A href="https://community.esri.com/t5/arcgis-dashboards-questions/how-can-i-improve-performance-of-this-arcade-data/m-p/1353315/highlight/true#M8768" target="_blank" rel="noopener">Link to my answer in the Dashboard Community</A></P> Sun, 26 Nov 2023 11:24:11 GMT https://community.esri.com/t5/developers-questions/how-can-i-improve-performance-of-this-arcade-data/m-p/1353316#M6836 JohannesLindner 2023-11-26T11:24:11Z https://community.esri.com/t5/developers-questions/how-can-i-improve-performance-of-this-arcade-data/m-p/1354063#M6837 <P data-unlink="true">For anyone facing similar issues, this is the way! The method outlined by <a href="https://community.esri.com/t5/user/viewprofilepage/user-id/294341">@JohannesLindner</a> in the <A href="https://community.esri.com/t5/arcgis-dashboards-questions/how-can-i-improve-performance-of-this-arcade-data/m-p/1353315/highlight/true#M8768" target="_self">Dashboard Community</A> made load times for a data expression 47 times faster than the previous method. Awesome!</P> Tue, 28 Nov 2023 14:56:43 GMT https://community.esri.com/t5/developers-questions/how-can-i-improve-performance-of-this-arcade-data/m-p/1354063#M6837 Vinzafy 2023-11-28T14:56:43Z