i have a feature layer stored in an oracle sde, this layer is the dissolve output of ~1M parcels (with lot of vertices), the problem is that when i am using this layer in arcmap with symbology the layer perfermance is good, but when this layer is displayed in web application using arcgis map service it displays very slow and take around 10 seconds.
why the display performance differs between arcmap and arcgis server for the same layer in the same data source??
Hi Elie,
This could possibly be a network issue. I would test this by exporting the feature class to a File Geodatabase. Copy the File Geodatabase to a folder on the Oracle server, publish a service, and see how performance is. Then, copy the File Geodatabase to a folder on the ArcGIS Server server, and publish a service from there to compare how the performance is.
If ArcMap is on the same machine as the Oracle database, then Jake Skinner's suggestion is a good test to go through.
You can also take a look at the Verbose logs, which will give you a more granular look at the export map process:
http://server.arcgis.com/en/server/latest/administer/windows/map-service-log-codes.htm
Take a look at the information under Example: ExportMapImage. After you enable the Time Elapsed column within the logs, you'll be able to see exactly how long each operation took. If the Data Access step takes a long time, then you know it's some sort of latency issue between your ArcGIS Server machine and the Oracle database.
hi Jonathan,
please can you help me to analyse the below log sheet extracted from the ArcGis server, what can you deduce as a conclusion from your perspective.
sorry for the long list below, but i dont know how to attach a file.
thank you,
Level | Time | Message | Code | Time Elapsed | Method name |
---|---|---|---|---|---|
VERBOSE | Jun 23, 2017, 11:25:34 AM | Number of features drawn: 5 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:34 AM | Symbol Drawing | 103023 | 0.00011 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:34 AM | Data Access | 103024 | 0.60359 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:34 AM | Symbolizing | 103024 | 0.00018 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:34 AM | Execute Query | 103024 | 0.04625 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:34 AM | Beginning of layer draw: حنيفة وروافده | 103000 | Map.Draw | |
VERBOSE | Jun 23, 2017, 11:25:34 AM | End of layer draw: الأحياء | 103001 | 0.00063 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:34 AM | Number of features drawn: 0 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:34 AM | Symbol Drawing | 103023 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:34 AM | Data Access | 103024 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:34 AM | Symbolizing | 103024 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:34 AM | Execute Query | 103024 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:34 AM | Beginning of layer draw: الأحياء | 103000 | Map.Draw | |
VERBOSE | Jun 23, 2017, 11:25:34 AM | End of preparation. | 10095 | 0.00071 | MapServer.ExportMapImage |
VERBOSE | Jun 23, 2017, 11:25:34 AM | Begining of preparation. | 10094 | MapServer.ExportMapImage | |
FINE | Jun 23, 2017, 11:25:34 AM | Extent:571235.878435,2696405.435963, 761962.033774,2780466.506441; Size:1366,592; Scale:577790.55 | 10138 | ||
FINE | Jun 23, 2017, 11:25:34 AM | Begin ExportMapImage | 10010 | MapServer.ExportMapImage | |
FINE | Jun 23, 2017, 11:25:34 AM | REST request received. Request size is 178 characters. | 100001 | /export | |
VERBOSE | Jun 23, 2017, 11:25:35 AM | Number of features drawn: 5 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:35 AM | Symbol Drawing | 103023 | 0.00003 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:35 AM | Data Access | 103024 | 0.60899 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:35 AM | Symbolizing | 103024 | 0.00016 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:35 AM | Execute Query | 103024 | 0.04211 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:36 AM | Number of features drawn: 5 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:36 AM | Symbol Drawing | 103023 | 0.00395 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:36 AM | Data Access | 103024 | 0.59875 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:36 AM | Symbolizing | 103024 | 0.00016 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:36 AM | Execute Query | 103024 | 0.03376 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:36 AM | Number of features drawn: 5 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:36 AM | Symbol Drawing | 103023 | 0.00138 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:36 AM | Data Access | 103024 | 0.72624 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:36 AM | Symbolizing | 103024 | 0.00064 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:36 AM | Execute Query | 103024 | 0.04144 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:37 AM | Number of features drawn: 5 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:37 AM | Symbol Drawing | 103023 | 0.0248 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:37 AM | Data Access | 103024 | 0.58133 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:37 AM | Symbolizing | 103024 | 0.00025 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:37 AM | Execute Query | 103024 | 0.14112 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:38 AM | Number of features drawn: 5 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:38 AM | Symbol Drawing | 103023 | 0.00243 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:38 AM | Data Access | 103024 | 0.62225 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:38 AM | Symbolizing | 103024 | 0.00017 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:38 AM | Execute Query | 103024 | 0.03416 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:38 AM | Number of features drawn: 5 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:38 AM | Symbol Drawing | 103023 | 0.00003 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:38 AM | Data Access | 103024 | 0.62662 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:38 AM | Symbolizing | 103024 | 0.00017 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:38 AM | Execute Query | 103024 | 0.03625 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:39 AM | Number of features drawn: 5 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:39 AM | Symbol Drawing | 103023 | 0.00314 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:39 AM | Data Access | 103024 | 0.59717 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:39 AM | Symbolizing | 103024 | 0.00016 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:39 AM | Execute Query | 103024 | 0.03336 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:40 AM | Beginning of layer draw: المناطق المغطاة بالأنظمة المعتمدة | 103000 | Map.Draw | |
VERBOSE | Jun 23, 2017, 11:25:40 AM | End of layer draw: وادي السلي | 103001 | 0.23067 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:40 AM | Number of features drawn: 2 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:40 AM | Symbol Drawing | 103023 | 0.00572 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:40 AM | Data Access | 103024 | 0.18493 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:40 AM | Symbolizing | 103024 | 0.00007 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:40 AM | Execute Query | 103024 | 0.03781 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:40 AM | Beginning of layer draw: وادي السلي | 103000 | Map.Draw | |
VERBOSE | Jun 23, 2017, 11:25:40 AM | End of layer draw: حنيفة وروافده | 103001 | 6.09187 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:40 AM | Number of features drawn: 5 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:40 AM | Symbol Drawing | 103023 | 0.00146 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:40 AM | Data Access | 103024 | 0.59812 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:40 AM | Symbolizing | 103024 | 0.00016 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:40 AM | Execute Query | 103024 | 0.04012 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:56 AM | End of layer draw: حرم خط الغاز | 103001 | 0.01711 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:56 AM | Number of features drawn: 1 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:56 AM | Symbol Drawing | 103023 | 0.00211 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:56 AM | Data Access | 103024 | 0.00277 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:56 AM | Symbolizing | 103024 | 0.00009 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:56 AM | Execute Query | 103024 | 0.01081 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:56 AM | Beginning of layer draw: حرم خط الغاز | 103000 | Map.Draw | |
VERBOSE | Jun 23, 2017, 11:25:56 AM | End of layer draw: المناطق المغطاة بالأنظمة المعتمدة | 103001 | 16.49729 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:56 AM | Number of features drawn: 1546 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:56 AM | Symbol Drawing | 103023 | 0.27281 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:56 AM | Data Access | 103024 | 16.02848 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:56 AM | Symbolizing | 103024 | 0.0375 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:25:56 AM | Execute Query | 103024 | 0.10768 | Map.Draw |
FINE | Jun 23, 2017, 11:25:57 AM | REST request successfully processed. Response size is 197605 characters. | 100004 | 22.98171 | /export |
FINE | Jun 23, 2017, 11:25:57 AM | End ExportMapImage | 10011 | 22.98007 | MapServer.ExportMapImage |
VERBOSE | Jun 23, 2017, 11:26:08 AM | Beginning of layer draw: حنيفة وروافده | 103000 | Map.Draw | |
VERBOSE | Jun 23, 2017, 11:26:08 AM | End of layer draw: الأحياء | 103001 | 0.00095 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:08 AM | Number of features drawn: 0 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:08 AM | Symbol Drawing | 103023 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:08 AM | Data Access | 103024 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:08 AM | Symbolizing | 103024 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:08 AM | Execute Query | 103024 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:08 AM | Beginning of layer draw: الأحياء | 103000 | Map.Draw | |
VERBOSE | Jun 23, 2017, 11:26:08 AM | End of preparation. | 10095 | 0.00081 | MapServer.ExportMapImage |
VERBOSE | Jun 23, 2017, 11:26:08 AM | Begining of preparation. | 10094 | MapServer.ExportMapImage | |
FINE | Jun 23, 2017, 11:26:08 AM | Extent:655297.980760,2732504.177465, 679139.822770,2743012.811597; Size:1366,592; Scale:72223.82 | 10138 | ||
FINE | Jun 23, 2017, 11:26:08 AM | Begin ExportMapImage | 10010 | MapServer.ExportMapImage | |
FINE | Jun 23, 2017, 11:26:08 AM | REST request received. Request size is 179 characters. | 100001 | /export | |
VERBOSE | Jun 23, 2017, 11:26:09 AM | Number of features drawn: 4 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:09 AM | Symbol Drawing | 103023 | 0.00003 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:09 AM | Data Access | 103024 | 0.62609 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:09 AM | Symbolizing | 103024 | 0.00012 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:09 AM | Execute Query | 103024 | 0.14973 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:10 AM | Number of features drawn: 4 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:10 AM | Symbol Drawing | 103023 | 0.00002 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:10 AM | Data Access | 103024 | 0.63097 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:10 AM | Symbolizing | 103024 | 0.0001 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:10 AM | Execute Query | 103024 | 0.08496 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:11 AM | Number of features drawn: 4 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:11 AM | Symbol Drawing | 103023 | 0.00004 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:11 AM | Data Access | 103024 | 0.5949 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:11 AM | Symbolizing | 103024 | 0.00015 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:11 AM | Execute Query | 103024 | 0.14694 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:11 AM | Number of features drawn: 4 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:11 AM | Symbol Drawing | 103023 | 0.005 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:11 AM | Data Access | 103024 | 0.71727 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:11 AM | Symbolizing | 103024 | 0.00058 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:11 AM | Execute Query | 103024 | 0.16438 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:12 AM | Number of features drawn: 4 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:12 AM | Symbol Drawing | 103023 | 0.0068 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:12 AM | Data Access | 103024 | 0.57387 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:12 AM | Symbolizing | 103024 | 0.00013 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:12 AM | Execute Query | 103024 | 0.04249 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:13 AM | Number of features drawn: 4 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:13 AM | Symbol Drawing | 103023 | 0.00277 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:13 AM | Data Access | 103024 | 0.58482 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:13 AM | Symbolizing | 103024 | 0.00015 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:13 AM | Execute Query | 103024 | 0.03063 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:13 AM | Number of features drawn: 4 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:13 AM | Symbol Drawing | 103023 | 0.00003 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:13 AM | Data Access | 103024 | 0.58812 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:13 AM | Symbolizing | 103024 | 0.00018 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:13 AM | Execute Query | 103024 | 0.03667 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:14 AM | Number of features drawn: 4 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:14 AM | Symbol Drawing | 103023 | 0.00433 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:14 AM | Data Access | 103024 | 0.59016 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:14 AM | Symbolizing | 103024 | 0.00015 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:14 AM | Execute Query | 103024 | 0.02971 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:15 AM | End of layer draw: وادي | 103001 | 0.17967 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:15 AM | Number of features drawn: 1 | 103019 | 0 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:15 AM | Symbol Drawing | 103023 | 0.00276 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:15 AM | Data Access | 103024 | 0.15937 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:15 AM | Symbolizing | 103024 | 0.00004 | Map.Draw |
VERBOSE | Jun 23, 2017, 11:26:15 AM | Execute Query | 103024 | 0.01537 | Map.Draw |
FINE | Jun 23, 2017, 11:26:19 AM | REST request successfully processed. Response size is 252896 characters. | 100004 | 10.32033 | /export |
FINE | Jun 23, 2017, 11:26:19 AM | End ExportMapImage | 10011 | 10.31943 | MapServer.ExportMapImage |
FINE | Jun 23, 2017, 11:26:27 AM | Begin ExportMapImage | 10010 | MapServer.ExportMapImage | |
FINE | Jun 23, 2017, 11:26:27 AM | REST request received. Request size is 179 characters. | 100001 | /export | |
FINE | Jun 23, 2017, 11:26:27 AM | Extent:664037.369389,2736947.981827, 669997.575335,2739574.970418; Size:1366,592; Scale:18055.95 | 10138 | ||
FINE | Jun 23, 2017, 11:26:34 AM | REST request successfully processed. Response size is 142644 characters. | 100004 | 7.23262 | /export |
FINE | Jun 23, 2017, 11:26:34 AM | End ExportMapImage | 10011 | 7.23177 | MapServer.ExportMapImage |
FINE | Jun 23, 2017, 11:26:39 AM | REST request received. Request size is 178 characters. | 100001 | /export | |
FINE | Jun 23, 2017, 11:26:39 AM | Extent:666072.976361,2737343.384273, 669053.190971,2738657.018988; Size:1366,592; Scale:9027.98 | 10138 | ||
FINE | Jun 23, 2017, 11:26:39 AM | Begin ExportMapImage | 10010 | MapServer.ExportMapImage | |
FINE | Jun 23, 2017, 11:26:46 AM | End ExportMapImage | 10011 | 6.85495 | MapServer.ExportMapImage |
FINE | Jun 23, 2017, 11:26:46 AM | REST request successfully processed. Response size is 127129 characters. | 100004 | 6.856 | /export |
The bulk of the time looks to be with ArcGIS Server attempting to access the data on your database (the data access phase), which is frequently due to some network issue. This happens prior to the query operations.
i tried Jonathan method and the results are very good in ArcMap and very bad in web application (the ArcGIS for server took around 35 s to display a 174 kb image).
i turned off all the layer in the MXD and turn it on one by one and republish (the map works very fast except for this big layer)
noting that after generalization the layer contains around 2.5 Millions vertices. (this layer added with complex symbology)
i am sharing with you all these information because it seems that ArcGIS for server has a specific problem with this layer.