Python tool won't stop running-- Not an infinite loop issue

Question

I'm having trouble with a python script. It is essentially a near duplicate of another script which is running fine-- it is using different files, but apart from that the tools used and the order in which the tools are used is basically the same.

When I go run my duplicate tool, it won't stop running. It doesn't have any logic in it which would cause it to go into an infinite loop. It is essentially just a string of tools and outputs. Does anyone know what it could be about this loop that is keeping it from successfully finishing?

I've tried including print statements, but it seems to freeze so the print statements won't print.

Here is the code (with path named edited):

import arcpy

arcpy.geoprocessing.env.overwriteOutput = True   
#Variables
asOldParcelsFC  = r"string"  
asBoundary = r"string"
scParcelsInAS = r"string" 
newNotInOld_preclip = r"string" 
newNotInOld = r"string"

arcpy.MakeFeatureLayer_management(asOldParcelsFC, "asOldParcels_layer")
arcpy.MakeFeatureLayer_management(asBoundary, "AltamonteBoundary")
arcpy.MakeFeatureLayer_management(scParcelsInAS, "scParcels")

arcpy.AddJoin_management("scParcels", "PARCEL", "asOldParcels_layer", "PARCEL", "KEEP_ALL")
arcpy.SelectLayerByAttribute_management("scParcels", "NEW_SELECTION", "asOldParcels.PARCEL IS NOT NULL")
arcpy.SelectLayerByAttribute_management("scParcels", "SWITCH_SELECTION")
arcpy.CopyFeatures_management("scParcels", newNotInOld_preclip)
arcpy.Clip_analysis(newNotInOld_preclip, "AltamonteBoundary", newNotInOld)

arcpy.Delete_management(newNotInOld_preclip)
arcpy.Delete_management("AltamonteBoundary")
arcpy.Delete_management("asOldParcels_layer")
arcpy.Delete_management("scParcels")

Answer 1

When working with large tables and performing joins I would recommend creating an attribute index for both tables, Add Attribute Index, this should help the overall process speed wise.