Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
8 subscribers
Views
1939 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
User Interface
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?
OriginalPostID-152339
OriginalPostID-152339
Discussion posts and replies are publicly visible
Parents
0
jaishankarj
over 9 years ago
We faced similar issue but not exactly the same. The steps which we followed are as follows:
1. Use execute stored procedure smart service
2. If possible use the view rather than fetchin whole data
3. Create index in the table from where data is being fetched
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
jaishankarj
over 9 years ago
We faced similar issue but not exactly the same. The steps which we followed are as follows:
1. Use execute stored procedure smart service
2. If possible use the view rather than fetchin whole data
3. Create index in the table from where data is being fetched
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data