JobResult Page Slow Loading

[jvanderaa]

Environment

• Python version: 3.8.10
• Nautobot version: 1.1.4

Steps to Reproduce

1. Execute Jobs via Golden Config Plugin, or self written
2. Navigate to primary JobResult page (Extensibility -> Job Results)
3. Page takes a long time to load compared to other pages (43 results)

Expected Behavior

Expected the page to load with relative expedience.

Observed Behavior

At least 45 seconds to load, the timer executed was at 50 seconds

[glennmatthews]

Related to #453; the issue is that JobResult log entries are all stored in a single JSON blob within the JobResult, so to summarize the logs for each JobResult in the list view, we have to parse the JSON for each JobResult as part of our rendering logic. When each JobResult has dozens to thousands of log entries in its JSON, this can be very expensive. The most likely fix will be to extract JobResult logs into a separate database model instead of storing them as JSON, which will allow us to summarize the logs with a much quicker simple database call.

[glennmatthews]

Fixed by #1030.