I assume that there is a physical Oracle table that sees insert/update events as the REST service fires.
And that those events aren't a complete truncate/reload.
If so I would create a before insert/update trigger and construct an sde.st_geometry object from the X,y columns. No indexes should exist before the initial load; create them after the load. As ...
So after comments are in...
Is it true that QGIS 3.10 does not work correctly with ArcGIS web services (MapServer)?
No, it's not true.
Your example service is expecting the bboxSR and imageSR parameters, but they are not required.
How to fix this behavior?
The service (not QGIS) has to be modified to change it's expectation for non-required ...
I need to be able to query the WMS based on a polygon
You can only query A WMS at a point location, via a GetFeatureInfo operation.
If you only want a certain area, only specify that as BBOX in a GetMap operation.
If you want to resymbolize the map based on some query, use a custom SLD in the GetMap.
It's all possible in OpenLayers
To confirm, what ...
Number 1 will have least overhead. Based on map extent used most often set smallest grid slightly smaller than this map extent zoomed to. Set next middle grid 3 times this value. Set largest grid three times the middle grid value. This works like a spatial index explained here:
As noted in the comments, version 10.0 does not use HTTP port 6080 to communicate. Based on this forum Q&A arcgis server 10.0 can't log to manager using 6080 port
At 10.0, you reach Server Manager through ports 80 and 443. Starting at 10.1, you'll reach Manager through 6080 and 6443.
If that or other ports outline below doesn't work. It may be the ...