Improve write performance

Question

I am trying to "delete;append" to a sharepoint list from an alteryx workflow in server and it appears to be very slow taking atleast 3 hours, not different from designer. I also tried doing an update instead of "delete;append" and it takes same amount of time. Is this is common when dealing with sharepoint write? Any tips/tricks much appreciated.

Thanks in advance

miteshnarottam · Answer

Hi Yurr24

Is it possible to raise your case directly with Alteryx Support, please? This may require further investigation. Please reach out to Support@Alteryx.com

Kind Regards

Mitesh Narotam

Yuri24 · Answer

I would think its a firewall if I see failure errors or 0 export. Data is exporting but very slow. N/W or Latency issues.

jamielaird · Answer

Hi @Yuri24 ,

It could be due to your firewall configuration, e.g. per this suggestion from @cpituley :

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Sharepoint-List-Input-Lag/m-p/159314/highlight/true#M41732