I have a sql view joined to a parcel layer for the entire city of New York (over 800k records). All data is registered to to the arcgis server. As you could imagine, this produces very slow response times in ArcGIS itself and when published to an online mapping service. Does anyone have any ideas on a different approach to linking this data or publishing methods to cut down loading times?

It looks like publishing a Tiled Service has improved speed but so far i am unable to toggle different layers off and on, furthermore, while my configured pop-ups remain in place, i am unable to reconfigure them.

closed as unclear what you're asking by PolyGeo Jan 12 '17 at 9:14

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • Have you set scale-based visibility for the parcel layer? For example, configure ArcGIS Server to only make the layer visible when zoomed to a specific scale such as 1:10000. As you've seen, showing 800k parcels at once is going to be very intensive. – Radar Sep 4 '15 at 16:39
  • 1
    Definitely! First step i took was limiting the visibility to 1:24,000 and the response times are still pretty dismal – GIS_Raver Sep 4 '15 at 16:44
  • There's an edit button beneath your question that you can use to provide additional information like this. – PolyGeo Sep 7 '15 at 0:55
  • Does the SQL view (or tables it is based on) have an index on the column you are using for the join? – Jon Lynch Jun 15 '16 at 23:43