How to Cache Large data file in Alteryx Analytical App

Question

The question is explained in the title itself. I am working on an Analytical App which will greatly benefit if I can cache some of the files in the workflow. I understand how to cache files in the workflow but don't understand if similar functionality is possible while running the app.

mceleavey · Answer

Hi @harshalsonioo1 ,

The short answer is, you can't.

Caching is used for when you're developing.

You can improve the processing speed of the app by changing the format and/or storage location of your larger files. If you're loading in large Excel files, for example, it might be more efficient to store these files as .yxdb files.

If you have a a huge data size of hundreds of millions of rows of data then you might want to look into Calgary functionality as this will allow huge data sources to be queried in seconds.

M.