This query is simple enoughtselect noteId , miscMattersMainId , createdOn, createdBy , note from PLSM_note
Those are the only fields in the table and only two records in PLSM_note,
This is being executed against the pre-defined data source that comes with Appian with almost no load on the server.For reference, when I run this same query in the loud Database/MyPHPAdmin I get
Showing rows 0 - 2 (3 total, Query took 0.0003 seconds.)So what's going on as it's taking more than five minutes to complete the execution?
Discussion posts and replies are publicly visible
There is a common misconception about Appian process performance. This is mixing up low level code execution time vs. node duration time. Appian is made to scale horizontally and can run millions of process instances at the same time. An individual process or node will not be run any faster.
Keep in mind, this is about implementing a business process and assigning tasks to people. People do not know that they will get a task assigned, so they do not wait for it.
Umm, so this is the assignmentI'm not too sure how your previous comment helps solve the issue
Me neither. What is the deal with the assignment? What are you looking for?
I would like to query the database and store the results in a list/array of records.My first step was to see if I could query the database.The initial process that I started a few days ago is still actually runningI'm not getting any errors, the node does have an assigned user.
I think the longer time is due to the assignment, the node will not stop executing until the form has been submitted.
OK. Then this node has failed. Please check the tomcat-stdout log file for any details.
Is there a specific reason to not use Appian's normal way of accessing the database?
I don't see how the system would have gotten to the "Script Task" had I not clicked the button for submit it.
I'm talking about the Form that you may have configured in the Query Database node as you are providing assignment for this node.
Solution to original question:
Select below highlighted option on the assignment tab
This solved the initial problem
Cool. But as Stefan and Mike also mentioned there is no ultimate need to use Query Database node for your use case.