Skip to main content
Known Participant
Apr 14, 2023 8:18 PM UTC
Solved

Query Database Node takes a long time

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?

    sanchitg0002
    Inspiring
    Apr 17, 2023 12:56 PM UTC

    Solution to original question:

    Select below highlighted option on the assignment tab 

    14 replies

    stefanhelzle0001
    Brainy
    Apr 15, 2023 9:20 AM UTC

    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.

    petel0001Author
    Known Participant
    Apr 17, 2023 12:42 PM UTC

    Umm, so this is the assignment

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

    stefanhelzle0001
    Brainy
    Apr 17, 2023 12:46 PM UTC

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