Super slow dragging in or import or input excel files from shared drive

[JokeFun]

Alteryx worked all fine in my 1st PC. Then it became an issue to open excel files, PDF, or PPT etc. one day, esp from the shared net work. So the company Tech guy helped to replace a new PC, which works all fine for these, except for Alteryx. Now, it takes more than 10 min to drag in a simple file of 190kb from the shared net work drive to the designer. It's only about 8 seconds on my colleague's. And I also tested one workflow which runs 1:08min on her machine, but takes 3:32 hours on mine. Tech said the hardware is normal. Restart PC does not work. Re-installation of the software either. I even replaced a third PC without any luck. Any suggestions on this? So far, it looks like related with my ID.

PS: It works normally if the input file is saved at local drive.

Test ID	Test Method	time for sheet name loading (Select Excel Input) not responding time	time for workbook loading (Entire Alteryx not responding time)	time for Input tool selection after loading (refresh preview 100 records)
1	primary PC	1m 45s	10min	10min
2	secondary PC	10-12s	70s	30s
3	Colleague on her Secondary	2s	8s	instant
4	Me on Colleague's sec	10-15s	40-74s	30s
5	Colleague on her primary	2s	8s	instant
6	Primary 2	1m 45s	10min	10min
7	my local drive	2s	8s	instant

[atcodedog05]

Hi @JokeFun 

The concern is with the shared drive the time taken is nothing but the time taken by the system to connect to the file. Sometimes same shared drive is considered as from a different network when using system with different domains. Also, this is not a direct issue with the PC but might be with the network configuration.

A quick check what you can do is copy the file onto your desktop, try connecting it and check whats the time taken.

Hope this helps : )

[JokeFun]

Hi @atcodedog05  ,

connecting to the same file copied to the local drive (C:\) is just normal. 

PS, the tech advised that those anti-virus software or any other scanning software is supposed to work in the same way for my colleague and me. But I really doubt they are doing additional data scrutiny with my ID.

[atcodedog05]

Hi @JokeFun 

Just confirming using files in the local system was faster right?

[JokeFun]

@atcodedog05 Exactly. Import from local drive is normal.

[JokeFun]

The conclusion is it's a specific problem with my ID, because even IT assigned a new HVD to me, it is still the same poor performance. I also tried to log on my colleague's HVD where her ID works quite well and mine the same poor performance. So now it can take hours as I am developing some complicated workflow. I tried to save all data source to local C drive at the very beginning, which helps a bit. But maintenance and update of the workflow after go-live have to be based on shared drive files, which is really a big headache for me.