KMgroup with large number of users causes performance and mgmt issues - reference SD02327321

Idea ID 1686827

KMgroup with large number of users causes performance and mgmt issues - reference SD02327321

1. Brief Description

The current design of knowledge management groups (kmgroups) in Service Manager is not scalable to kmgroups with 10,000 operators. Login time can exceed 30 seconds easily.

We identified the cause in the fact that the kmgroup record contains an array with all operators belonging to this group – hence queries to which kmgroup contains in this array the current user is slow.

When sqldebug:1 is activated, there should many many Selects on kmgroupa1 table.

In this context, I’d also like to refer to existing ER QCCR1E60037.

2. Briefly describe your idea

Storing the members of a kmgroup in array inside the record is not scalable: So the members should be stored outside in a way that can be efficiently queried.

3. Benefits / Value

This design change will improve performance.

4. Explain why is this important? (When used, by which role, and benefits / value)

As default membership for large user group is required, this is causes issues especially for large customers.

Design details

There should be different possible approaches to make this more efficient like:

* Storing kmgroup name in operator records – then finding the kmgroups is just picking up the values from here

* Storing (operator, kmgroup) pairs into a new table.

 

5. Explain how would you like this idea designed / implemented

Well, it’s the outcome that counts.

If I’d about to make the design, I’d tend to:

* Storing (operator, kmgroup) pairs into a new table.

1 Comment
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor
Status changed to: Waiting for Votes
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.