performance suggestions/tips for record producer

kkronborg · ‎08-02-2016

I have a record producer that have 58 variables (!!) where 8 variables are reference types, 7 are date types, 12 are select box types, 22 are single line text types, 3 are lookup select box types and a few other types. This record producer takes appx. 1 minute and 30 seconds to load which is not acceptable by the end user. Does anyone have suggestions/tips for improving the load time for this record producer (besides removing some of the variables) ?

Thanks.

Chuck Tomasi · ‎08-02-2016

This makes me very sad. The main reason for record producers is to give the user a great data input experience with real questions instead of field labels and few things to fill out instead of an entire large detailed form. Consider the OOB incident record producer - 4 questions.

Anyway, use the response time indicator on the form to help diagnose where the time is coming from. It's that little clock that nobody ever seems to notice in the lower right corner. Click it once it provides some detail. Click the browser link and you get details about what is going on client side.

Response Time Indicator - ServiceNow Wiki

Troubleshooting Performance - ServiceNow Wiki

View solution in original post

kkronborg · ‎08-04-2016

Hi Chuck,

It turned out to be a calculated value for a field that was triggered for each record read in a table. This calculation called a script include which performed a gliderecord query and that happened for all records in the table - not so good. But David Piper from servicenow support was great in helping me with debugging this and the calculated value is now deactivated. The server response time went from over 100 seconds to 1.3 second when I did that

Thanks again for pointing me in the right direction

/Kim

Chuck Tomasi · ‎08-04-2016

Excellent. Those are the kinds of problems where eyes on your screen is vastly more helpful than Q & A back and forth in the community.

I'm glad you got your question answered. Thank you for participating in the community.