Measuring Visual Task Board performance

Colin Wilson
Giga Guru

Do you know if there is a way to measure performance related issues on a visual task board? 

 

We have a freeform visual task board that takes about 25-40 seconds every time it loads. The vtb has 1100 cards (~400 active, ~700 archived) and 38 lanes. We have our card limit set to 1000. This is on UI16.

Typically in most forms there is the response time indicator at the bottom right, but it looks like its not in the VTB UI. We only get the 'running transaction' info message that appears after 15 seconds or so.

Docs indicates that the default limit is 2000, with performance hits above 1000. The way this article is written makes me think that this is more of a display render limit, but i'd love for some clarification on that as well. Do archived cards not count against this limit?

Thanks in advance for your help!

1 ACCEPTED SOLUTION

Hi Vinothkumar,

 

Yes, thanks for reminding me to post what I got back from HI!

 

Here is essentially what the issue is, per HI:

  1. VTB Load times are taking long due to the data itself
  2. For each vtb_task, an SQL query is happening on the task table, and internally checking checklist data from the checklist_item table. the long load time is due to that the sql queries run sequentially, and the large amount of data increases the time for each specific query. 

The official response to this was 'This is working as per the design and we can't optimize this.'

The only other advice offered was setting a lane limit to 100, though the performance improvement this would offer would be marginal; maybe less than a 5%-10% increase in performance. Seeing as our VTB only had 38 lanes, this was not relevant to us, but it could be for you. 

I've attached a .txt document of the verbatim reply from HI. 

Thanks,

Colin

 

View solution in original post

4 REPLIES 4

vinothkumar
Tera Guru

Hello Collin,

 

Have you got answer for your question, I also had the same doubt. Our users are facing slowness and the browser become irresponsive, if the board has 1000 cards and more than 150 Lanes. 

Hi Vinothkumar,

 

Yes, thanks for reminding me to post what I got back from HI!

 

Here is essentially what the issue is, per HI:

  1. VTB Load times are taking long due to the data itself
  2. For each vtb_task, an SQL query is happening on the task table, and internally checking checklist data from the checklist_item table. the long load time is due to that the sql queries run sequentially, and the large amount of data increases the time for each specific query. 

The official response to this was 'This is working as per the design and we can't optimize this.'

The only other advice offered was setting a lane limit to 100, though the performance improvement this would offer would be marginal; maybe less than a 5%-10% increase in performance. Seeing as our VTB only had 38 lanes, this was not relevant to us, but it could be for you. 

I've attached a .txt document of the verbatim reply from HI. 

Thanks,

Colin

 

ServiceNow Tec2
Mega Sage
This has been resolved by ServiceNow Technical Support. Please refer to KB0752546 for more information.

ServiceNow Tec2
Mega Sage
This has been resolved by ServiceNow Technical Support. Please refer to KB0770062 for more information.