Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.

Add the hextoraw functionality to improve the CI history information tab response

Idea ID 2699108

Add the hextoraw functionality to improve the CI history information tab response

The UCMDB is already using the hextoraw function over the 98+% of the time, The recommendation is to set that function at the 100%  of the sql querys to avoid the impact over the UCMDB performance.

Performance: Modify the queries to set the hextoraw function (as per almost all the queries in UCMDB)

Original Query, access index by start_time

SELECT ID,CMDB_ID,END1_ID,END2_ID,START_TIME,CHANGE_TYPE,CHANGER_INFO,CHANGER_DATASTORE FROM HDM_190710COMPOSITION_1

WHERE 1=1 

AND START_TIME >= :v0   AND START_TIME <= :v1  

AND HDM_190710COMPOSITION_1.END1_ID IN ( :v2 )

AND HDM_190710COMPOSITION_1.CHANGE_TYPE IN ( :v3 ,  :v4 ,  :v5,  :v6 )

 

Tune query , access by end1_id

SELECT ID,CMDB_ID,END1_ID,END2_ID,START_TIME,CHANGE_TYPE,CHANGER_INFO,CHANGER_DATASTORE FROM HDM_190710COMPOSITION_1

WHERE 1=1 

AND START_TIME >= :v0   AND START_TIME <= :v1  

AND HDM_190710COMPOSITION_1.END1_ID IN hextoraw( :v2 )

AND HDM_190710COMPOSITION_1.CHANGE_TYPE IN ( :v3 ,  :v4 ,  :v5,  :v6 )

 

Case: SD02532257 Performance: Modificar el código para agregar la función hextoraw

 

3 Comments
Micro Focus Expert
Micro Focus Expert
Status changed to: Declined

Unfortunately, since the Idea Exchanges relies on the votes from the CMS community to indicate overall value, the standard language is English for the overall Idea Exchange scope.

While I have done the Google translate to get an understanding of what you’re requesting, it’s very unlikely others in the community will do the same.  Would you resubmit your request in English?  It would provide a much better opportunity for your idea to get support from the rest of the CMS community

I tried to write to you directly, but it appears your email address used to submit this idea is not accepting incoming emails.

Micro Focus Expert
Micro Focus Expert
Status changed to: Waiting for Votes

Thank you for sharing your idea! It’s open for comments and kudos, and we’re looking forward to input from the community. Once there is enough community traction, it will be further reviewed by the product team

Micro Focus Expert
Micro Focus Expert
Status changed to: Accepted

Great news, this idea has been accepted on our product roadmap. Subscribe to receive updates. (This is not a formal commitment, and subject to change)

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.