KBI 310696 Issue Addressed: Slow Loading Time Of Relator Testing Dialog Box

Version

Argent Advanced Technology 3.1A-1308-A or below

Date

Friday, 4 Oct 2013

Summary

The Relator testing dialog box can take over two minutes to load when the number of licensed nodes exceeds 2,000 nodes

Technical Background

Argent AT read through SQL tables of both licensed node (ARGSOFT_{PRODUCT}_LICENSED_NODE) and CMDB-X (ARGSOFT_AT_NODE) in order to load the Relator testing dialog box.

Both these SQL tables can contain thousands of rows, and can leads to slow loading

Argent AT 3.1A-1310-A and later has enhanced relevant SQL queries and uses in-memory cache.

The performance improvements decrease loading time from 120 seconds to 2 seconds

Resolution

Upgrade to Argent Advanced Technology 3.1A-1310-A or later