cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Query XML execution is extremly slow

Jump to solution

Hi!

I'm facing issues with the "Query XML" action. It is executing extremly slow. It needs minutes to complete even though the XML is rather small:

<Item>
      <MiejsceKontroliStatus type="System.String">USZKODZONY</MiejsceKontroliStatus>
      <MiejsceKontroliElementOk type="System.Boolean">False</MiejsceKontroliElementOk>
      <MiejsceKontroliZdjecie type="System.String">&amp;lt;a href=&amp;quot;https://image_URL&amp;quot; target=&amp;quot;_blank&amp;quot;&amp;gt;&amp;lt;img width=&amp;quot;400&amp;quot; src=&amp;quot;https://image_URL&amp;quot; /&amp;gt;&amp;lt;/a&amp;gt;</MiejsceKontroliZdjecie>
      <MiejsceOpis type="System.String">Some description</MiejsceOpis>
      <MiejsceKontroliOpis type="System.String">Some description</MiejsceKontroliOpis>
      <MiejsceStatus type="System.String">USZKODZONY</MiejsceStatus>
      <MiejsceZdjecie type="System.String">&amp;lt;a href=&amp;quot;https://image_URL&amp;quot; target=&amp;quot;_blank&amp;quot;&amp;gt;&amp;lt;img width=&amp;quot;400&amp;quot; src=&amp;quot;https://image_URLg&amp;quot; /&amp;gt;&amp;lt;/a&amp;gt;</MiejsceZdjecie>
      <RejonMiejsca type="System.String">Some string</RejonMiejsca>
      <IDMiejsca type="System.String">Some ID</IDMiejsca>
      <MiejsceKontroliReakcja type="System.Boolean">True</MiejsceKontroliReakcja>
      <CzestotliwoscMiejsca type="System.String">Tydzień</CzestotliwoscMiejsca>
      <MiejsceKontroliUsterka type="System.String">Some description</MiejsceKontroliUsterka>
</Item>‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The xpath queries I'm using are not complex either, ex.: "//IDMiejsca".

I have to admit, I never faced such issue before. Execution of five actions takes around 30 minutes (!!!)

Any suggestions?

Regards,

Tomasz

Labels: (1)
0 Kudos
Reply
5 Replies
Workflow Hero

Re: Query XML execution is extremly slow

Jump to solution

Hi Tomasz,

Can you message me a workflow history URL for an instance where this is happening? We can take a look to see where the latency is coming from.

Thanks,


Callum

0 Kudos
Reply
Workflow Hero

Re: Query XML execution is extremly slow

Jump to solution

So it seems it was just a temporary issue with the Nintex infrastructure. Problem solved.

0 Kudos
Reply
Workflow Hero

Re: Query XML execution is extremly slow

Jump to solution
0 Kudos
Reply
Workflow Hero

Re: Query XML execution is extremly slow

Jump to solution

Is there maybe another update on this? I am developing a workflow that contains some loops, query and update xml actions and an approval, it takes extremely long. 

I logged "start task process" to history list before I assign a task (in parallel) - 2 minutes later my task gets assigned.

Sometimes is takes 4 minutes to get out of a loop containing a very simple Update XML action, similar to Thomasz's.

My flow is taking almost 20-30 minutes for doing the following:

- Query XML to get repeating section contents

- Looping through the results to put them in in a variable (only 2 lines in my repeating section containing both only 2 nodes)

- Assigning a parallel task to 2 users

- Querying the tasks to retrieve the comments (only the two relevant task ID's)

- Update the XML of my repeating section in a loop

Thank you. 

0 Kudos
Reply
Workflow Hero

Re: Query XML execution is extremly slow

Jump to solution

Hi Glenda,

Not aware of any issues with the Query XML performance right now - would it be possible for you to PM me a workflow history URL to an instance, I can check our records and see if I can see where the time is being taken.

Thanks,

Callum

0 Kudos
Reply