Idea ID: 2699108

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

Status : Delivered
over 1 year ago

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

 

Tags:

  • This idea has been implemented in product release CMS 2020.02. Check out the enhancement page of the release notes for details. Thanks to all of our contributors for helping us continue to improve our products!

  • 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)

  • 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

  • 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.