Copy Features from joined layer speed

727
2
08-28-2013 10:59 AM
AndrewMoffitt
Occasional Contributor III
In model builder, I have a model that takes the iterative table input and joins it to a point (28k count) file using the Add Join tool.
The join happens rather quickly, but the Copy Features takes almost 2 minutes. 

If I execute the same series of event from the table of contents, the data export only takes around 10 seconds.

Both are going to a local SSD.

[ATTACH=CONFIG]27064[/ATTACH]

Any ideas as to the what and why for this being so much slower?
0 Kudos
2 Replies
DaleHoneycutt
Occasional Contributor III
My first response is that Copy Features is being executed once per iteration, so that's what causes the slow-down.  Are you saying that it takes 2 minutes per iteration?
0 Kudos
AndrewMoffitt
Occasional Contributor III
EDIT: Yes it takes 2 minutes per iteration.

I have since removed the Copy Rows as shown in the original picture.  It was left over from my attempts to see if I could speed up the Copy Features.

Below is the code from a single run-through of the model.
This is iterated for every text file within my input folder.

Succeeded at Wed Aug 28 16:10:36 2013 (Elapsed Time: 0.00 seconds)
Executing (Make Feature Layer): MakeFeatureLayer C:\3111\postrun\17_sal\GIS\Mesh_Nodes.shp Mesh_Nodes_Layer # # "FID FID VISIBLE NONE;Shape Shape VISIBLE NONE;NodeID NodeID VISIBLE NONE;Easting Easting VISIBLE NONE;Northing Northing VISIBLE NONE;Z Z VISIBLE NONE;Existing Existing VISIBLE NONE"
Start Time: Wed Aug 28 16:10:36 2013
Succeeded at Wed Aug 28 16:10:36 2013 (Elapsed Time: 0.00 seconds)
Executing (Iterate Tables): IterateTables C:\3111\postrun\17_sal\GIS\Tables # # NOT_RECURSIVE
Start Time: Wed Aug 28 16:10:36 2013
Succeeded at Wed Aug 28 16:10:36 2013 (Elapsed Time: 0.00 seconds)
Executing (Make Table View): MakeTableView C:\3111\postrun\17_sal\GIS\Tables\35_45ty1_y3jul_sal_avg.txt 35_45ty1_y3jul_sal_avg_View # # "Field1 Field1 VISIBLE NONE;Field2 Field2 VISIBLE NONE"
Start Time: Wed Aug 28 16:10:36 2013
Succeeded at Wed Aug 28 16:10:36 2013 (Elapsed Time: 0.00 seconds)
Executing (Add Join): AddJoin Mesh_Nodes_Layer NodeID 35_45ty1_y3jul_sal_avg_View Field1 KEEP_ALL
Start Time: Wed Aug 28 16:10:36 2013
Succeeded at Wed Aug 28 16:10:36 2013 (Elapsed Time: 0.00 seconds)
Executing (Copy Features): CopyFeatures Mesh_Nodes_Layer C:\3111\postrun\17_sal\GIS\EntireMeshNodes\35_45ty1_y3jul_sal_avg_Nodes.shp # 0 0 0
Start Time: Wed Aug 28 16:10:36 2013
Succeeded at Wed Aug 28 16:13:11 2013 (Elapsed Time: 2 minutes 35 seconds)
Executing (Remove Join): RemoveJoin Mesh_Nodes_Layer #
Start Time: Wed Aug 28 16:13:11 2013
Succeeded at Wed Aug 28 16:13:11 2013 (Elapsed Time: 0.00 seconds)
0 Kudos