I have a layer, looks like the attachment below. I would like to publish this as a map service to use in a web map application. It will only be for display purposes/background. But performance is quite poor when running it through mxdperfstat, mostly the three query layers. Looking for some ideas on possibly how to improve the performance or maybe a better way to view/use the layer. These poor results even occur at a scale of 1:1000. I would like to be able to display the legend also.
Here's a snapshot of the mxdperfstats results: