Reducing server load

[yockee]

Say I have a point feature class with 100K points that fall into 4 categories. This will be published into a map service that will be used by many clients.

Which one is better to reduce server load :

- publishing all 100K data and then filter it in web map by their categories

- filter the data by categories in arcgis pro and then publish it

thanks

[berniejconnors]

If the features are filtered in the web map I believe the load would be carried by the end-user's web browser.  So less load on your server.

Bernie.

[yockee]

So both options are equally fine. is it  ?

[berniejconnors]

Testing is the only way to know for sure.  Publish the service in your DEV environment using both methods.  And then examine your ArcGIS Server log file to see which service generates more log messages.

[yockee]

Turns out that this option is the best :  *filter the data by categories in arcgis pro and then publish it*.

It seems, when he whole data is published, they are all transferred to the portal and reside somewhere. No matter how we filter the data in web map, the portal is still under heavy load. 

So, I wonder where the data are stored in the portal ? I am using enterprise geodatabase (postres 13), arcgis enerprise 11.0. The feature services that are published are not hosted, meaning that all edits go into database straight away.

[LavanyaVasudevanNES]

This also really comes down to the cores/memory on the server/portal machines along with how you have set up the services (dedicated or shared).  Services that are used highly should be set to Dedicated.  

[yockee]

Yes,

I fiddled around with heap memory setting and the number of dedicated instance.

The more heap memory allocated and the more dedicated instances are added, the quicker the system crashed. 

I also test using shared instances. Turn out that the maximum instances created by arcgis server are only 7. LoL. No wonder it crashed when I set to dedicated instances to 9.

[George_Thompson]

Is this machine the same one that you posted about the tile package crashing?

https://community.esri.com/t5/arcgis-enterprise-portal-questions/portal-suddenly-down-in-the-middle-...