Work without connecting calling database over and over

[Ricardo_Montero]

Hi all,

Just wondering if there is a way to bring a huge data set from a database and kind of "save it in the workspace" so that with any additional change the workflow won't connect to the database again so that it could run faster.

Many thanks!

[echuong1 · Accepted solution]

Use the "cache and run" feature. Right click on a tool where you want the workflow to cache the data up to, and then click cache and run. The data will be saved in temp space and the data won't be re-run through the tools cached. 

There are limitations to which tools can be cached - generally tools with one output node can be cached. Let me know if that helps!

https://community.alteryx.com/t5/Engine-Works-Blog/Just-take-the-Cache-and-Run-Caching-in-2018-3/ba-...

[Ricardo_Montero]

Perfect! Great stuff!