Input Data Tool is slow when data is from shared drive

milbertdacudao

The workflow was running fast until September 16, 2021. When running in local drive, the workflow average runtime is 15 seconds. However, when we run it in the shared drive, it takes 30.36 minutes to complete the run.

We have enabled the Performance Profiling and found out that the Input Data Tool result is this: Info: Get Input Files (380): Profile Time: 1835608.88ms, 100.00%

It took approximately 30 minutes just to run the input files which contains 45 fields and 407 records.

BrandonB

Hi @milbertdacudao 

The biggest difference is that your computer needs to pull the data across your network in order to process it when it sits on the network drive whereas it can just pull the data immediately when it is stored locally. That being said, this does seem like an abnormal amount of time. This is something that I would suggest checking in with your IT team. This likely either has to do with a VPN connection that you are using or it has to do with the network drive itself. How long does it take your computer to copy the file from the network drive to your desktop? If copying the file is relatively quick, I might suggest sending an email to support@alteryx.com. However, if copying the file from the network drive to your computer is very slow, this might be a good indication that something is wrong with your IT infrastructure.