Hi Sarah Ambrose,
I made some performance test (for now only with hosted FL). I used the GeoAnalytics "Aggregate Points" tool. My setup is the following.
1. I had a FL stored in a Postgres-Geodatabase (around 800,000 features, ESPG 31493).
2. I created two Portal FL services from that data:
a.) a FL with data referenced to the DBMS and
b.) a FL with data copied to Relational DS of the portal.
Running the tool it takes for a.) around 7 minutes and for b.) around 1 minute.
- The strange thing is, if I use ESPG 3857 instead of 31493 both test only take around 2 minutes with the same dataset. Why that? I could use 3857 instead but being in northern europe the distances of the squares or hexagones are very disturbed.
- When running the tool with the referenced data (a.)) the GeoAnalytics Server logs show the following:
WARNING 05.04.2018 09:45:29 Internal error: Failed to get serviceDefinition for https://<portalURL>:6443/arcgis/rest/services/bussgeld_31493_pg/FeatureServer/0 System/GeoAnalyticsTools.GPServer
SEVERE 05.04.2018 09:45:29 REST call to 'https://<portalURL>:6443/arcgis/rest/admin/services/bussgeld_31493_pg/FeatureServer' failed (reason=Server returned error: [Service 'bussgeld_31493_pg' does not exist or is not started.]) System/GeoAnalyticsTools.GPServer
Might that be the reason with using the tool with a.) is soooo slow? Is there any way around to fix that?
Thanks,
Carsten