WMS or normal feature layer - 7 million records

Question

Hello,

I have a customer who has a feature layer with 7 million records, published to ArcGIS Enterprise (4 cores).

When using this layer in webapps or dashboards, with or without filters, the response is very slow.

What are the advantages of using an OGC WMS service to publish this layer?
What are the disadvantages?

What are the functional differences between publishing a feature layer from ArcGIS Enterprise, or a layer in the OGC WMS standard, using ArcGIS Enterprise?

Thanks!
Diego

George_Thompson · Answer

How are the resources on the PostgreSQL machine?

Is the Server machine pegged out when querying the layer?

DiegoMendes_Rodrigues · Answer

Are they trying to show all the features? No, symbology has been adjusted to show features at the proper zoom level.

What is the RDBMS being used and the relation to the Enterprise machines? PostgreSQL/PostGIS. One server for PostreSQL, one for ArcGIS Server, one for Portal.

Is the service an ArcGIS Server feature service right now? Yes.

George_Thompson · Answer

Are they trying to show all the features?

What is the RDBMS being used and the relation to the Enterprise machines?

Is the service an ArcGIS Server feature service right now?