0

Oracle 18c; 10.7.1 EGDB; ArcGIS Desktop 10.7.1

I have a non-spatial WORKORDER table that has X & Y columns. The table has 10,000 records.

I’ve created an XY event layer from the table in ArcMap.

The performance of the XY event layer has been surprisingly good, considering the shape field is generated on-the-fly. As far as I can tell, the XY event layer refreshes in the map almost as fast as a feature class does (the difference is negligible). Whereas a spatial view on the same table performs much slower (using an SDE.ST_GEOMETRY or an SDO_GEMETRY column; generated on-the-fly).

Question:

I would like to understand more about how different layer types perform in ArcGIS.

Do XY event layers have any built-in/dynamic optimization mechanisms (like a spatial index) that would account for the surprisingly good performance?

2
  • 2
    Perhaps this is not a duplicate but you could at least link your previous question that is dealing with the same observation gis.stackexchange.com/questions/380120/…. BTW did the spatial index make the materialized view fast?
    – user30184
    Nov 25 '20 at 11:36
  • @user30184 Yes, the spatial index made the MV wicked-fast.
    – User1973
    Nov 26 '20 at 2:50
1
+50

The XY event layer is generated on the client-side after all required library/data has been downloaded on the client machine, therefore there is no client-server connection required. It is also fast because it is generated from the Computer's RAM. In contrast, if you are querying geometry from DB, a client-server connection is required and a query is performed on the DB server which causes the latency.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.