analytical app taking time to start

[Labhesh]

Hi 

i have created an app save in .yxwz but whenever i am tring to run that app by double clicking on it it takes time to open it or it never opened.

same within the alteryx also whenever i try to run it as an analytical app insise the alteryx alteryx start not responding mode.

What is the soution to this ?

[apathetichell]

What are your interface tools you are using for your app? Does it draw on an external data source to populate a listbox or dropdown? Is that datasource huge? most likely this is a workflow issue - not specific to your app but it also could be that your app is configured totally wrong in a way which I can't imagine which would affect this. I can't tell because you haven't provided any screenshots of any configurations or of your workflow.

[Labhesh]

Hi @apathetichell 

My data source is from yxdb that has 252million rows, fixed source from the same folder where workflow is saved.

top container is for all the filters used in worksflows with drop down & list boxes,

middle one is for ETL process,

middle last one from summarizing set,

botton one is for the enabling/ disabling detour.

[apathetichell]

Do you need all 252 million rows to create your interface tools? If so - Alteryx has to get that into memory to generate your workflow. this is going to take forever... you can test if this is true by changing the source file you are using for your interface tools to say 25 rows - and seeing if it load quicker.

[Labhesh]

@apathetichell 

App is already created i have to show the demo that is why i need provide whole data for processing.

In future app will be uploaded to gallery with input access to sharepoint but input still be in saved on sharepoint as yxdb and from gallery user will be able to run the app for their need.

[apathetichell]

You can have 252mm rows as a data source but it may take a while to load. you cannot have 252mm rows being ingested/manipulate to create your interface tools. 

where does the data for these come from - top container is for all the filters used in worksflows with drop down & list boxes?

if these are subset of the 252mm rows (and they are small) and the 252mm rows is static - you can chain this where app 1 - creates the aggregations from the 252mm rows for the interface tools. app 2 runs with the smaller amount data. you cannot have 252mm rows directly in a drop down or list box. It will not work.

[Labhesh]

As I mentioned above only 252m rows is my data source only 1st input tool in workflow.

in interface tools like list box, drop down data source having between 10-50 rows per tool for interface tools and preparation for that is done before this as you mentioned.

[apathetichell]

ok - so then it could just be loading your data takes forever. I'd have to do more testing to see why you are seeing such a long time to load your interface tool. the options are (1) your data is all being loaded into memory. (2) something is wrong in your workflow. (3) your workflow is waiting on something.

[Labhesh]

It will be some difficult for me to share the data as working has my firm info not very much but still have.

any other way that i can debug 

[apathetichell]

first off - if you run via wand in designer does it run? how long does it take? what happens if you use a subset of data. how much memory is there on your machine? Where is your huge .yxdb located? have you ever run this much data in a workflow?