Alteryx slow to write to db

[Dan5]

I write tables to postgres, and it takes several days to write in Alteryx. Or it takes 500s to import via pgadmin. What is going on? Can i improve the performance from Alteryx with settings?

[RishiK]

@Dan5  What does your workflow look like when writing to the db? This performance issue might be down to a number of things such as:

- Other areas of the workflow being expensive - can you run Performance Profiling on your workflow to find out where the bottlenecks are?

- Are you leveraging our in-db tools?

- Whats running on the db at the same time?

[Dan5]

Thanks for your response, 

I generally write locally to an xydb file first. Then run a separate workflow that simply goes from xydb directly to the db table, with nothing else in the workflow. Curious about performance profiling, and how that could help optimize my workflow; i can generally see which boxes take longer to process, data cleansing for example..

I generally leave the default settings in output, which might help?

i am not using the in-db tools, simply using output, and picking my connection and table. 

Nothing else is happening in the db at the time, and doing an import through pgadmin seems to upload much faster. 

[RishiK]

@Dan5 this link might help you https://www.thedataschool.co.uk/debora-contente/quick-tip-where-is-alteryx-wasting-your-time/

It might be something on the database side if its just an Input tool going into an output to the database.

Have a look at the in-db tools also:

https://www.theinformationlab.co.uk/2019/04/09/a-quick-guide-to-in-db-tools-part-1/