Hi.. We have an entity backed record which queries on a view. The view is a unio

Sharmila Nagaraj

A Score Level 1

over 9 years ago

Hi.. We have an entity backed record which queries on a view. The view is a union between two tables. When we click on a related action on this record, it always takes time, close to 6 seconds, to render the task UI. But if I check the Process Nodes to verify how long it took for each node, I can see that all the nodes upto the first UI task has been completed within a second. Any idea what could be the cause to this slowness, if the problem is not with the related action process model?

Discussion posts and replies are publicly visible

0 Jacob Cohen - Project Leader - Macedon Technologies over 9 years ago

Have you looked into the performance of the Interface itself? It could be that you are querying directly on the form.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sharmila Nagaraj
A Score Level 1
over 9 years ago

@jacobc, the interface loads within 5ms.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 marky over 9 years ago

You could always try optimizing the view and/or removing unneeded columns from the view. Another option is to use a table instead of a view, where the table is generated or updated asynchronously (something like an ETL) during process execution. As the previous poster said, first verify where the problem is: (interface or view), then work on solving that piece. If the problem is in the interface, pasting the interface code in this thread would allow us to help you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel