New answers tagged performance
Currentyly there is a method to filter geometries within some distance in PostGIS that uses spatial index: http://postgis.net/docs/ST_DWithin.html
PerfQAnalyzer does just that. From that page: In the Spring of 2012 we released the PerfQAnalyzer tool, which assists users in capturing render and edit times within ArcGIS for Desktop. This tool is a free, unsupported, downloadable tool offered to the Esri user community which can be run from within ArcMap (as an add-in) or as a stand-alone ArcGIS ...
I think you should try mxdperfstat: An ArcGIS Engine command line tool to diagnose typical mxd performance problems. Supports ArcGIS 9.3, 10, 10.1, 10.2, 10.3 versions.
For questions like these, I find Tom MacWright's Mapmakers Cheat Sheet useful. In your particular case, look at the section about lines: https://github.com/tmcw/mapmakers-cheatsheet#lines. As already mentioned by @john-barça, a tiling solution is probably best; I'm personally not a fan of WMS though, I usually find mbtiles etc easier to work with.
is the area field a float? you may want to try creating the area index (clustered or non) on an integer field (if your use case can accept the generalization).
First and foremost, work with layers for better performance -- therefore, after you create the feature class, turn it into a feature layer using the MakeFeatureLayer tool...then add all your fields to that layer. Second option, and this is perhaps the fastest way, try using a numpy array: narray = numpy.array(, numpy.dtype([('INTID', numpy.int), ...
Top 50 recent answers are included