Extreme difference in identify times between 100.2 and 100.4

[JoeHershman]

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 Name	Time Seconds (API = 100.4)	Time Seconds (API = 100.2)	Increase (ms)	Identify Time Change
Gas Leaks	0.0709587	0.0839489	-1.29902	Decrease
Repaired Gas Leaks	0.256843	0.0079967	24.88463	Increase
Change Request	0.0069962	0.0179866	-1.09904	Decrease
Meters	1.5430591	0.0169923	152.60668	Increase
Regulator Station	0.0189887	0.0169907	0.1998	Increase
Compressor Station	0.0119933	0.0171815	-0.51882	Decrease
Critical Valves	0.063961	0.0179909	4.59701	Increase
Non Critical Valves	0.1778903	0.0189875	15.89028	Increase
Test Stations	0.0089948	0.0149901	-0.59953	Decrease
Coupon	0.0149913	0.0169892	-0.19979	Decrease
Relief Valve	0.0159903	0.0169946	-0.10043	Decrease
Pressure Monitoring Device	0.0199876	0.0179843	0.20033	Increase
Rectifier	0.025984	0.0159899	0.99941	Increase
Odorizer	0.0149906	0.0159895	-0.09989	Decrease
Pig Structure	0.0199865	0.015991	0.39955	Increase
Sniff Test Location	0.0259856	0.0189887	0.69969	Increase
Locator Device	0.0669575	0.1082403	-4.12828	Decrease
Exposed Pipe	0.0109939	0.0109939	0	Decrease
Encroachment	0.0169904	0.0169896	8E-05	Increase
WOF	0.0159894	0.0169907	-0.10013	Decrease
TFIR	0.0149906	0.01699	-0.19994	Decrease
Drip	0.0349796	0.0169884	1.79912	Increase
Crossing	0.026985	0.0169895	0.99955	Increase
Fittings	0.8374883	0.0279835	80.95048	Increase
Rectified Pipe	4.190445	0.0079933	418.24517	Increase
Gas Pipe Casing	0.0169889	0.0169911	-0.00022	Decrease
Customer Service Zones	0.0169903	0.0189886	-0.19983	Decrease
Shop Location	0.0159899	0.0189872	-0.29973	Decrease
Total	7.5633898	0.6271185

Thanks

-Joe

[JoeHershman]

I can send the database, I just need an ftp location to send to.  I had previously tried using the methods to identify all layers and not seen a noticeable improvement, but I can try again.  I do this way to filter out layers being identified (e.g., they are not visible), so I did not have to process layers not needed, but could as easily filter the results if that appraoch is faster.  Will give a try when I have some time.

[dotMorten_esri]

I sent you an email earlier today. Let me know if you didn't get it.