On a harvest project, we have a number of files (especially pdf) and while checking out it is taking atleast 10-15 minutes to find a file for checkout, and this behavior started happening after the upgrade. It is happening for bunch of users who access the files from that project only.
Release : 14.0
We increased logging level to 5 and reproduced the problem.
The top 2 sql statements were both the same statement:
INSERT INTO VCTEMP2
SELECT DISTINCT I.ITEMOBJID, MAX(I.VERSIONOBJID) AS VERSIONOBJID
FROM VCTEMP1 I, harItems I1
WHERE I.ITEMOBJID = I1.ITEMOBJID
AND I.ITEMOBJID IN (SELECT USRGRPOBJID
FROM HARUSRGRPTEMP)GROUP BY I.ITEMOBJID
In both of these cases the number of rows updated was 10488.
This appears to be happening only with one project where the number of items being checked out is over 10,000. All other examples of this query in the log files run within a second or two and return only 30 or fewer rows.
An efix was provided and user added "-vcoptflag11" to the HServer.arg file