AnsweredAssumed Answered

Most Resource Intensive ST_Geometry Functions?

Question asked by blake.terhune on Mar 26, 2018
Latest reply on Mar 27, 2018 by bixb0012

I'm working with an Oracle DBA to design a Python script that will test the performance of our organization's enterprise geodatabase (currently on 10.5.1). I want to make sure it stresses the database server and not the client running the script so I was planning to use  arcpy.ArcSDESQLExecute() with some particularly intense ST_Geometry SQL functions.  Our primary focus is CPU testing but I'd like a good, all-around test case. Any suggestions or advice?

 

Python

Managing Data

Outcomes