AnsweredAssumed Answered

MakeFeatureLayer_management Performance Issue

Question asked by jamesfreddyc on Dec 14, 2017
Latest reply on Dec 14, 2017 by jamesfreddyc

I'm seeing wildly different performance when establishing Feature Layers in different SDE databases.

 

ws1 = r'\\somenetworkpath\gdb1.sde'
fcname = r'gdb1.someschema.FCNAME
input_fc1 = os.path.join(ws1, fcname)
arcpy.MakeFeatureLayer_management(input_fc1, "input_fl1")

ws2 = r'\\somenetworkpath\gdb2.sde'
fcname = r'gdb2.someschema.FCNAME
input_fc2 = os.path.join(ws2, fcname)
arcpy.MakeFeatureLayer_management(input_fc2, "input_fl2")

 

In the above examples, ws1 takes over 6 seconds on the MakeFeatureLayer_management line, while the other is sub-1 second!

 

ws1 is a "publication" SDE database where no editing is done.  ws2 is non-versioned editing.

 

Any input or what to look for?


Thanks!

Outcomes