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
On the form, collect the records to be deleted. Pass these to the process and use the deleteRecords node to delete them.
And as I discussed in at least one other thread already with this user, there's no need to use the Query Database node in this manner at all. Query Record or Query Entity should be being called in a Script Task (or, as you suggest, on the start form) and saving their output into the process.
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.