Highlighted
Trusted Contributor.
Trusted Contributor.
242 views

HP SM 9.34. quereis to <userinfo> table take more than 10 sec during user login.

Hello, experts,

we have complaints from users that login time is almost 1 min.

we open MS SQL 'Activity monitor' for HPSM database and see that most time-consuming queries (10-20 sec) are to the <userinfo> like:

SELECT m1."LOGINNAME", m1."CLIENTIP" ,COUNT(*) FROM USERINFOM1 m1
--WHERE ((m1."LOGINNAME" like 'user@test.com'))
GROUP BY m1."LOGINNAME", m1."CLIENTIP"
ORDER BY m1."LOGINNAME", m1."CLIENTIP"

I open this table and it has less than 300 records - it's the number of logged in users.

1. why query to this table is so long and take 10-20 secs?

2. how to fix it?

3. we have tried to add index in dbdict to this table (loginname, clientip columns) but it doesn't help.

0 Likes
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.