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.