Skip to main content
P
petel0001
April 14, 2023
Solved

Query Database Node takes a long time

  • April 14, 2023
  • 14 replies
  • 0 views

This query is simple enought

select 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?

    Best answer by sanchitg0002

    Solution to original question:

    Select below highlighted option on the assignment tab 

    14 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    April 15, 2023

    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.

    P
    petel0001Author
    April 17, 2023

    Umm, so this is the assignment

    I'm not too sure how your previous comment helps solve the issue

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    April 17, 2023

    Me neither. What is the deal with the assignment? What are you looking for?

    Terms & ConditionsAccessibility statement