Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Google Sheets Performance Issues

Kanderson
10 - Fireball

I have a workflow that ends by inserting records into a google doc. Each run is fairly small and produces about 1500 rows. However, the dataset does have 60 columns. The workflow takes a very long time to complete, and commonly times out. I have already broken down the workflow into smaller runs, and I am still having issues.

 

Has anyone run into similiar performance issues for this tool? Any advice?

 

Thank you

 

Kevin

 

 

1 REPLY 1
JessicaS
Alteryx Alumni (Retired)

Hello,

 

I tested with 1500 records (70 columns) uploading to new google sheet and the process took 4:43 minutes

Testing with 4248 records (70 columns) uploading again to new google sheet the process took 7:18 minutes

 

I have attached the test data I used here in case you want to test with the same dataset.

 

If you are still having issues, consider checking the memory settings and optimization steps outlined in the page below

 

http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tips-amp-Tricks-2016-Workflow-Optimization/ta...

 

I am working in alteryx 10.6, system information below

info.PNG

Jess Silveri
Manager, Technical Account Management | Alteryx
Labels