I am trying to test some of my 2.7 python scripts on 3.6 python and i noticed a huge difference on amount of time it takes to run the FeatureClassToFeatureClass_conversion process. so with 3.6 python the process took 18 min 5 secs, with 2.6 python it took only 8 seconds. Does anyone know why the it take much longer in 3.6 Python? This is what i am using, there is more fields than this i just removed a lot of them. PT1 = "C:/Temp/Scratchworkspace.gdb/Drain" def Layers15 ( PT1 ) : FieldMapString = "" \ + "" "PIN " PIN" true true false 13 Text 0 0 , First , #,""" + PT1 + """,Pin,-1,-1;"""\ + "" "ACRES " ACRES" true true false 4 Double 0 0 , First , #,""" + PT1+ """,ACRES,-1,-1;"""\ + "" "Instrument " Instrument" true true false 10 Text 0 0 , First , #,""" + PT1 + """,Instrument,-1,-1;"""\ + "" "SiteAddres " SiteAddres" true true false 106 Text 0 0 , First , #,""" + PT1 + """,SiteAddres,-1,-1;"""\ + "" "SiteCity " SiteCity" true true false 32 Text 0 0 , First , #,""" + PT1 + """,SiteCity,-1,-1;"""\ + "" "SiteZip " SiteZip" true true false 10 Text 0 0 , First , #,""" + PT1 + """,SiteZip,-1,-1;"""\ + "" "SubName " SubName" true true false 20 Text 0 0 , First , #,""" + PT1 + """,SubName,-1,-1;"""\ fieldmappings = arcpy . FieldMappings ( ) fieldmappings . loadFromString ( FieldMapString ) return fieldmappings def main ( args = None ) : if args is None : args = sys . argv # Process: Feature Class to Feature Class arcpy . FeatureClassToFeatureClass_conversion ( PT1 , "C:/Temp/Scratchworkspace.gdb" , "PT_ALL" , "" , Layers15 ( PT1 ) , "" )

which means you don't have 'line magics' so you have an older IDE (try spyder, you will have to replace timing stuff with whatever you use)

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Feature Class To FeatureClass conversion 2.7 python vs 3.6 Python

CCWeedcontrol

I am trying to test some of my 2.7 python scripts on 3.6 python and i noticed a huge difference on amount of time it takes to run the FeatureClassToFeatureClass_conversion process. so with 3.6 python the process took 18 min 5 secs, with 2.6 python it took only 8 seconds. Does anyone know why the it take much longer in 3.6 Python?

This is what i am using, there is more fields than this i just removed a lot of them.

PT1 <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:/Temp/Scratchworkspace.gdb/Drain"</SPAN>

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">Layers15</SPAN><SPAN class="punctuation token">(</SPAN>PT1<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    FieldMapString <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN> \

                <SPAN class="operator token">+</SPAN> <SPAN class="string token">""</SPAN><SPAN class="string token">"PIN "</SPAN>PIN" true true false <SPAN class="number token">13</SPAN> Text <SPAN class="number token">0</SPAN> <SPAN class="number token">0</SPAN> <SPAN class="punctuation token">,</SPAN>First<SPAN class="punctuation token">,</SPAN><SPAN class="comment token">#,""" + PT1 + """,Pin,-1,-1;"""\</SPAN>
                <SPAN class="operator token">+</SPAN> <SPAN class="string token">""</SPAN><SPAN class="string token">"ACRES "</SPAN>ACRES" true true false <SPAN class="number token">4</SPAN> Double <SPAN class="number token">0</SPAN> <SPAN class="number token">0</SPAN>  <SPAN class="punctuation token">,</SPAN>First<SPAN class="punctuation token">,</SPAN><SPAN class="comment token">#,""" + PT1+ """,ACRES,-1,-1;"""\</SPAN>
                <SPAN class="operator token">+</SPAN> <SPAN class="string token">""</SPAN><SPAN class="string token">"Instrument "</SPAN>Instrument" true true false <SPAN class="number token">10</SPAN> Text <SPAN class="number token">0</SPAN> <SPAN class="number token">0</SPAN> <SPAN class="punctuation token">,</SPAN>First<SPAN class="punctuation token">,</SPAN><SPAN class="comment token">#,""" + PT1 + """,Instrument,-1,-1;"""\</SPAN>
                <SPAN class="operator token">+</SPAN> <SPAN class="string token">""</SPAN><SPAN class="string token">"SiteAddres "</SPAN>SiteAddres" true true false <SPAN class="number token">106</SPAN> Text <SPAN class="number token">0</SPAN> <SPAN class="number token">0</SPAN> <SPAN class="punctuation token">,</SPAN>First<SPAN class="punctuation token">,</SPAN><SPAN class="comment token">#,""" + PT1 + """,SiteAddres,-1,-1;"""\</SPAN>
                <SPAN class="operator token">+</SPAN> <SPAN class="string token">""</SPAN><SPAN class="string token">"SiteCity "</SPAN>SiteCity" true true false <SPAN class="number token">32</SPAN> Text <SPAN class="number token">0</SPAN> <SPAN class="number token">0</SPAN> <SPAN class="punctuation token">,</SPAN>First<SPAN class="punctuation token">,</SPAN><SPAN class="comment token">#,""" + PT1 + """,SiteCity,-1,-1;"""\</SPAN>
                <SPAN class="operator token">+</SPAN> <SPAN class="string token">""</SPAN><SPAN class="string token">"SiteZip "</SPAN>SiteZip" true true false <SPAN class="number token">10</SPAN> Text <SPAN class="number token">0</SPAN> <SPAN class="number token">0</SPAN> <SPAN class="punctuation token">,</SPAN>First<SPAN class="punctuation token">,</SPAN><SPAN class="comment token">#,""" + PT1 + """,SiteZip,-1,-1;"""\</SPAN>
                <SPAN class="operator token">+</SPAN> <SPAN class="string token">""</SPAN><SPAN class="string token">"SubName "</SPAN>SubName" true true false <SPAN class="number token">20</SPAN> Text <SPAN class="number token">0</SPAN> <SPAN class="number token">0</SPAN> <SPAN class="punctuation token">,</SPAN>First<SPAN class="punctuation token">,</SPAN><SPAN class="comment token">#,""" + PT1 + """,SubName,-1,-1;"""\       </SPAN>
                            

    fieldmappings <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>FieldMappings<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
    fieldmappings<SPAN class="punctuation token">.</SPAN>loadFromString<SPAN class="punctuation token">(</SPAN>FieldMapString<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">return</SPAN> fieldmappings


<SPAN class="keyword token">def</SPAN> <SPAN class="token function">main</SPAN><SPAN class="punctuation token">(</SPAN>args<SPAN class="operator token">=</SPAN>None<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">if</SPAN> args <SPAN class="keyword token">is</SPAN> None<SPAN class="punctuation token">:</SPAN>
                args <SPAN class="operator token">=</SPAN> sys<SPAN class="punctuation token">.</SPAN>argv

<SPAN class="comment token"># Process: Feature Class to Feature Class</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>FeatureClassToFeatureClass_conversion<SPAN class="punctuation token">(</SPAN>PT1<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"C:/Temp/Scratchworkspace.gdb"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"PT_ALL"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> Layers15<SPAN class="punctuation token">(</SPAN>PT1<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

All comments

bixb0012

You answered Dan's question about the field mapping being necessary, but did you try copying without using a field mapping? In terms of isolating the issue, it is important to know whether the field mapping is contributing to the problem or if it something else.

DanPatterson_Retired

Over the last 10 years since python 2.x, python 3 has had a number of changes to the datetime module and dates in general

datetime — Basic date and time types — Python 3.7.2 documentation

you should check out some of the changes and/or new features

CCWeedcontrol

I upgrade to Pro 2.3 this morning and now i am getting this error on line 81 and i didn't change the script at all.

RuntimeError: ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.

import sys, arcpy, os, fnmatch

from datetime import datetime as d
startTime = d.now()
start_time = time.time()


# Local variables:
print ('Started')
arcpy.env.overwriteOutput = True
arcpy.env.workspace = "C:/Temp/Scratchworkspace.gdb"
arcpy.env.qualifiedFieldNames = False
arcpy.env.preserveGlobalIds = True

PT1 = "C:/Temp/Scratchworkspace.gdb/Drain"

FieldMapString = '''
DXF_TEXT "DXF_TEXT" true true false 11 Text 0 0 ,First,#, {0}, ACRES,-1,-1;
ACCOUNT "ACCOUNT" true true false 11 Text 0 0 ,First,#, {0}, ACCOUNT,-1,-1;
PIN "PIN" true true false 13 Text 0 0 ,First,#, {0}, PIN,-1,-1;
ACRES "ACRES" true true false 4 Double 0 0  ,First,#, {0}, ACRES,-1,-1;
Instrument "Instrument" true true false 10 Text 0 0 ,First,#, {0}, Instrument,-1,-1;
SiteAddres "SiteAddres" true true false 106 Text 0 0 ,First,#, {0}, SiteAddres,-1,-1;
SiteCity "SiteCity" true true false 32 Text 0 0 ,First,#, {0}, SiteZip,-1,-1;
SiteZip "SiteZip" true true false 10 Text 0 0 ,First,#, {0}, SiteZip,-1,-1;

'''
#print(FieldMapString.format(PT1))

def Layers15(PT1, FieldMapString):
    """pass the variable and the constant into
    the function
    """
    fieldmappings = arcpy.FieldMappings()
    fieldmappings.loadFromString(FieldMapString)
    return fieldmappings

def main(args=None):
        if args is None:
                args = sys.argv

# Process: Feature Class to Feature Class
arcpy.FeatureClassToFeatureClass_conversion(PT1, "C:/Temp/Scratchworkspace.gdb", "PT_ALL","", Layers15(PT1, FieldMapString),"")

print ("Finished")
print ('(Elapsed time: ' + str(d.now() - startTime)[:-3] + ')')

try:
    print ('(Elapsed time: ' + str(d.now() - startTime)[:-3] + ')')

except Exception as e:
    # If an error occurred, print line number and error message
    import traceback, sys
    tb = sys.exc_info()[2]
    print ("Line %i" % tb.tb_lineno)
    print (e.message)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DanPatterson_Retired

When you run Check My ability to run ArcGIS pro on the help page

ArcGIS Pro 2.3 system requirements—ArcGIS Pro | ArcGIS Desktop

does it pass... errrr more importantly, does it surpass the highest recommendations?

Do you run other stuff like browsers, social media and other unnecessary fluff when you are trying this?

Pro is going to be slower apparently since people are complaining about it, but I can assure you it has nothing to do with Python

CCWeedcontrol

Yes because the field mapping rearranges the fields which is linked to a reporting tool. Unless there is another way to rearrange the fields?

All my data is on my local PC, i have noticed slowness with Pro 2.2. I haven't upgraded to Pro 2.3 yet.

DanPatterson_Retired

is your field mapping necessary? Just try a copy features tool to compare speed. It may be either things are slower in your environment or it is now just slower.

I haven't noticed any tool slowness at all in Pro 2.3, but I have beefy machines and I use local data. It could be the way data is served/handled from sde or whatever if it isn't locally stored. It seems to be a common thread for those that are on the "slow train"

CCWeedcontrol

With Dan Petterson suggestions it took 16 min 40 secs in Python 3.6.

CCWeedcontrol

Joshua,

Yes very same computer. None of the code was changed.

CCWeedcontrol

It's always been the way i have done it. Thanks for the suggestion i will try it out.

bixb0012

Is this code running on the same machine?

DanPatterson_Retired

PT1 = 'HELLO'

FieldMapString = '''
PIN "PIN" true true false 13 Text 0 0 ,First,#, {0}, Pin,-1,-1;
ACRES "ACRES" true true false 4 Double 0 0  ,First,#, {0}, ACRES,-1,-1;
Instrument "Instrument" true true false 10 Text 0 0 ,First,#, {0}, Instrument,-1,-1;
SiteAddres "SiteAddres" true true false 106 Text 0 0 ,First,#, {0}, SiteAddres,-1,-1;
SiteCity "SiteCity" true true false 32 Text 0 0 ,First,#, {0}, SiteCity,-1,-1;
SiteZip "SiteZip" true true false 10 Text 0 0 ,First,#, {0}, SiteZip,-1,-1;
SubName "SubName" true true false 20 Text 0 0 ,First,#, {0}, SubName,-1,-1;
'''
print(FieldMapString.format(PT1))<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

def Layers15(PT1, FieldMapString):
    """pass the variable and the constant into
    the function
    """
    fieldmappings = arcpy.FieldMappings()
    fieldmappings.loadFromString(FieldMapString)
    return fieldmappings<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

don't know about the speed thing, but that ugly string in a function surely had to go.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.