We're experiencing a slowdown when loading a lot of data from the DB to be u

nickh647 over 9 years ago

We're experiencing a slowdown when loading a lot of data from the DB to be used in a form. What we're doing is loading up all of the data from the DB, applying a filter based on user input, and showing the results all on the same page. The user input is based off a mathematical function, so using the Appian query rules isn't an option.
The initial data load takes about 15 seconds, so when the user clicks a "Next" button to get to the page it hangs.
Has anyone else ran into this issue with a long load time, and how did it get resolved?

Discussion posts and replies are publicly visible

Parents

0 nickh647 over 9 years ago

So I ended up splitting up the SQL function into pieces we could use with a!queryEntity and a!queryLogicalExpression. We were using a mathematical function based on user inputs, but luckily I was able to find another version of the function that allowed me to split it up into distinct parts. Thanks for all your help!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 nickh647 over 9 years ago

So I ended up splitting up the SQL function into pieces we could use with a!queryEntity and a!queryLogicalExpression. We were using a mathematical function based on user inputs, but luckily I was able to find another version of the function that allowed me to split it up into distinct parts. Thanks for all your help!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data