AnsweredAssumed Answered

GenerateRoutes tool extremely slow

Question asked by bin.chen on Aug 13, 2018



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!