Hi Kelly,
In this case I am not trying to display thousands of feature on a map, but show a tabular result from a query that may return up to a couple hundred rows from a table layer within a hosted feature service. The feature service contains a primary feature layer (index 0) consists of a few thousand polygons, and a related table (index 1) that has no feature/shapes and contains over a million records based on one(polygon)-to-many(records) relationship.
Since I limit my application functionality to only query one polygon at a time, the related data returned based on querying just one polygon ID is not overwhelmingly large. Perhaps this is not the best model for display our dataset, but in uploading and testing the related table, it begs that question, what is the size and performance limit of even simple tabular data on ArcGIS Online? Seems like we've hit the limit.
I understand there are certain output limits to a hosted feature layer, such as the 2000 features limit, but I wonder if you guys have done any internal testing as far as how LARGE a single dataset hosted can be, in terms of number of features, rows, and fields? I would be nice to have some guideline so we can design our catalog to work most efficiently, without the need for manually curating each dataset for different resolutions and scale displays. We work often on California statewide dataset scale. It is difficult enough to keep track of publishing/utilizing 3 difference types of services for each dataset already (tile layer, feature layer, and dynamic map image layer).
Thank you,
Dean
