AnsweredAssumed Answered

GenerateRoutes tool extremely slow

Question asked by bin.chen on Aug 13, 2018

Hello,

 

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!

Outcomes