I'm doing a project which needs automation for a migration process. I am using the arcpy.GenerateRoutes_locref which is ok when the target table is on FileGDB (around 3 mins to complete). But when the target table is on SqlServer or Oracle geodatabase, it is extremely slow (more than 1 hour 20 mins).
The ALRS related tables have indexes created.
Does any one have any experience on this tool? I cannot try this on ArcCatalog as I only have the server license for Location Reference. So I run the script with 64-bit arcpy.
Any suggestion is really appreciated!