I am updating a field for a feature class that is on an enterprise geodatabase in SQL server. This is an ArcSDE connection.
My goal is to search for null values, and convert these to 0. The script is currently run through python on ArcCatalog 10.3. This is the part of the script in question:
fc= r"C:\Users\migrate\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\OZ@DB_MAPS.sde\DB.OZ.BaseMap\DB.OZ.PlantCenter" arcpy.MakeFeatureLayer_management (fc, "fc_temp") with arcpy.da.UpdateCursor ("fc_temp", fieldID) as cursor: for row in cursor: if row == None: row = 0 cursor.updateRow(row)
This dataset has about 20,000 entries, and the processing time is immense (over an hour at this point) for this part of the script. Is there a way to change the code to improve processing time for update cursors?