Does the size of data fields included in the attribute table of a feature class affect the performance if the feature class is published?

[AhmadSALEH1]

Does the size of data fields included in the attribute table of a feature class affect the performance if the feature class is published?

Hello,

I am wondering if the number of the fields included in the attribute table of a feature class affect the performance if the feature class is published.

Let’s assume that I have 2 F.C’s both of them contains a 1000 features, but one of them have 20 fields and the other one have 5 fields, now  if the features was published using the ArcGIS server, will the one with the 5 fields will be more efficient than the one with 20 fields. Does the number fields affecte the layer performance or the server performance or both of them?!

Regards,

Ahmad Saleh

[DanPatterson_Retired]

You first have to consider the file size.  1000 points with 20 fields of a single integer value is going to be smaller than 1000 polygons with 5 fields of large floating point numbers.  Load times are one thing, querying is another.

[AhmadSALEH1]

Hi Dan,

Let’s say that I have a F.C that have 1000 points and 5 fields, then I added another 15 fields to the same F.C, and now I have a F.C with 1000 points and 20 Fields.

What the might be effects of this operation (Performance,...,…)

Many Thanks,

Ahmad Saleh

[DanPatterson_Retired]

I am talking file size on disk not the number of features or rows...their type and content will control file size

[RebeccaStrauch__GISP]

Ahmad, some times you just need to do a test with your real data.  Maybe turn on the browsers "dev tools" to see timing.   If you do test, it wouold be interesting to hear your results.  As Dan mentioned, there are too many variables that can make a difference.