analytical app taking time to start

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 ?

Developer

Developer Tools

Custom Tools

Batch Macro

Help

Run Command

Iterative Macro

Accepted answers

All comments

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.

Capture.PNG

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?

Labhesh

@apathetichell

1.If i run via wand it takes app to load around 30-40min just to open the interface.

2.after giving all the inputs in interface it take around 5min to produce the output.

3.128gb ram with 8 core

4.huge yxdb is located in the same drive folder where workflow is saved

5.yes if i run the workflow as it is it take around 15min to give the output ( not as app).

apathetichell

This sounds like something in your app interfaces needs to read in the entire .yxdb before launching. If that is true - change it. It can't work that way. If it isn't true - try chained apps - app 1 -> interface tools. app 2 -> process. Workflow will always take a while to run - but interface tools shouldn't take forever to load.

Labhesh

Hi @apathetichell

thanks for the i will to use chained app.

as i start few months back on alteryx can you share me any link where the process you mentioned is available so that i can replicate here.

i dont have chainned tool Available with me

apathetichell

google around this forum - chained apps are app 1) does something and creates a value app 2) - takes in the values from app 1. the importance in your case is that your interface tools will not be reliant upon loading your full data set. I asusme you are correct and you are not using your full dataset to create the values for your interface tools. If you are - you need to rework that first.

Labhesh

Yes thanks i will look into this 👍

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703