Want to know the difference in speed of copy_management vs copyfeatures_management

Question

I am trying to copy from an Oracle ArcSDE 9.x database to an AWS postgres geodatabase very specific datasets including indexes.

At present I am using arcpy as I have to automate the process.

Specifically I am using copy_management. Some datasets take a minute or 2 to copy and some take over a day.

I was wondering if copyfeatures_management would be any quicker to use? If so, does anyone have any metrics?

mody_buchbinder · Answer

You should think about copy to a local FGDB (or shape), zip it, load it to AWS and then copy it locally on the clod into the database.

The network handle 1 big file must better then many small packages.

With big files it usually much quicker.

George_Thompson · Answer

I would highly recommend only connecting to the GDB in the cloud from a machine in the same cloud and region for better performance.

RobLane · Answer

I have definitely experienced the inconsistencies in performance which is why I would like to investigate improving the speed.... if at all possible