I have the following script:
import arcpy from arcpy import env import datetime import os env.workspace = r"Q:\\SDE\Direct Connection to Contours.sde" dataFC = arcpy.ListFeatureClasses("","","Contours") outpath = r'C:\Users\TEST\Desktop\SDE Conversion Project\TEST.gdb' query = "objectid > 0 AND objectid <= 200000 " for fc in dataFC: if fc == 'Contours': output = outpath + os.sep + fc arcpy.Select_analysis(fc, output+'200k', query)
Currently it selects records that have objectid between 0 and 200,000 and creates a feature class called Contours 200k in the TEST gdb.
What I want to be able to do is make a multiprocessing script that utilises one core to calculated between object id 0 and 200k, another that calculates betweek 200,001 and 400k and so on until the whole feature class is copied over as separate feature sets to the TEST gdb.
How would I go about doing that? I'm trying to do this since the bottleneck of copying from the sde is the network connection and testing with separate files where I had the ranges set manually improved the overall speed a lot.