ArcGIS Server map service performance suffers when time zone is set

1489
4
12-21-2020 12:25 PM
MatthewCarey
Occasional Contributor

I have a map service with 4 layers within it, all of which contain date-time fields. The most date-intensive layer has 6 fields containing dates and times. 

The layers are being served up from an Oracle geodatabase, and I'm using ArcGIS Server 10.7.1. 

The dates and times are recorded in US Eastern Standard Time (GMT - 5). In a web application, the times would show in pop-ups as 5 hours earlier than the time in the database/feature class, apparently interpreting the times as UTC.

The way to remedy this seemed to be to go into the map service parameters and specify the Eastern time zone, and also check on the daylight savings checkbox:

MatthewCarey_0-1608581247305.png

In the pop-ups the correct time was displayed, but the rendering performance of the map service instantly went way down, and Severe warnings appeared in the ArcGIS Server logs saying "Error performing query operation. Wait time of the request to the service '<service name>' has expired."

On setting the time zone back to None, the service's good performance returned.

Has anyone else run into a similar issue? Is it possible that a layer with ~100,000 records and 6 date and time fields could have its performance affected by the time zone settings? If so, is there a better way to get the right dates and times in pop-ups?

Thanks!

 

 

 

Tags (1)
0 Kudos
4 Replies
by Anonymous User
Not applicable

Hi Matthew,

Do you happen to have an index set up on the date fields at the feature class level? 

https://desktop.arcgis.com/en/arcmap/latest/map/time/best-practices-for-storing-temporal-data.htm#ES...

-Calvin

MatthewCarey
Occasional Contributor

Hi,

No, there are no indexes set up on those fields so far. Thanks for sending that info, that's got to be worth a try.

Hope to report back with progress.

Thanks a lot,

Matt

MattFancher1
New Contributor III

Matt - Did you resolve this? I've run into the same problem. Thanks in advance.

0 Kudos
MattFancher1
New Contributor III

Esri Support told me this is a known bug:

https://support.esri.com/en/bugs/nimbus/QlVHLTAwMDEzMDk3OQ==

It is supposedly fixed at 10.9.

I asked about a hot fix for 10.7.1, but haven't heard back yet.