boyle.matt

Append Views with Python 3

Discussion created by boyle.matt on Dec 19, 2018
Latest reply on May 6, 2019 by mcavoye

I'm curious if anybody has tried loading (appending) enterprise views (Sql Server 2014 Standard in our case) into feature classes using python 3.x with Pro?  We have several views that contain geometry (Sql geometry) that are used to compile data from various sources and then load them into non-versioned datasets using truncate and append tools.

 

This process works fine when using python 2.x, however, we've starting testing this process with python 3.x and we've had to kill our python 3.x scripts because we can't tell if any progress is being made. For example, we have a 100k+ parcel dataset that loads in about 5 minutes using python 2.x, but at 30 minutes with python 3.x we killed the script.

 

Curious if any others have tried or tested this, and if you've noticed any differences between python 2.x and 3.x.

Outcomes