minerjoe

Extreme difference in identify times between 100.2 and 100.4

Discussion created by minerjoe on Mar 26, 2019
Latest reply on Apr 8, 2019 by minerjoe

I have an application that was upgraded to the 100.4 version of the API.  In testing this application I see huge difference in the overall performance of the identify.  What is odd is that not all layers perform worse, some actually seem to perform better.  However, the ones that perform worse are significant (4 seconds in one case, 1.5 in another).  While I have not done an exhaustive evaluation of the layers themselves, it would seem that layers with more data a decrease in performance of the largest amounts.

 

What is going on here?  Because of the magnitude of the increase with specific layers I have an identify operation go from 0.6 seconds to 7.5 seconds.  It should go without saying that having a user wait 7 seconds for identify results is not acceptable

 

I also observe a noticeable difference in the performance of a polygon search on a large offline database although I have not logged the actual performance.

 

These tests are using the same offline replicas, identifying the same layers. The only difference being, I changed the API from 100.4 to 100.2 (and fixed the breaking changes)

 

Layer NameTime Seconds (API = 100.4)Time Seconds (API = 100.2)Increase (ms)Identify Time Change
Gas Leaks0.07095870.0839489-1.29902Decrease
Repaired Gas Leaks0.2568430.007996724.88463Increase
Change Request0.00699620.0179866-1.09904Decrease
Meters1.54305910.0169923152.60668Increase
Regulator Station0.01898870.01699070.1998Increase
Compressor Station0.01199330.0171815-0.51882Decrease
Critical Valves0.0639610.01799094.59701Increase
Non Critical Valves0.17789030.018987515.89028Increase
Test Stations0.00899480.0149901-0.59953Decrease
Coupon0.01499130.0169892-0.19979Decrease
Relief Valve0.01599030.0169946-0.10043Decrease
Pressure Monitoring Device0.01998760.01798430.20033Increase
Rectifier0.0259840.01598990.99941Increase
Odorizer0.01499060.0159895-0.09989Decrease
Pig Structure0.01998650.0159910.39955Increase
Sniff Test Location0.02598560.01898870.69969Increase
Locator Device0.06695750.1082403-4.12828Decrease
Exposed Pipe0.01099390.01099390Decrease
Encroachment0.01699040.01698968E-05Increase
WOF0.01598940.0169907-0.10013Decrease
TFIR0.01499060.01699-0.19994Decrease
Drip0.03497960.01698841.79912Increase
Crossing0.0269850.01698950.99955Increase
Fittings0.83748830.027983580.95048Increase
Rectified Pipe4.1904450.0079933418.24517Increase
Gas Pipe Casing0.01698890.0169911-0.00022Decrease
Customer Service Zones0.01699030.0189886-0.19983Decrease
Shop Location0.01598990.0189872-0.29973Decrease
Total7.56338980.6271185

 

Thanks

-Joe

Outcomes