if I'm not wrong there is a patch correcting this issue. 7.1 p 4 SW00295427
Performance issues occurred with BMC Remedy User after upgrading to version 7.0.01 patch 005. Note: The actual Server Name and Schema Name were replaced in the cache so that BMC Remedy User would not send requests to the AR System server for each field. ________________________________ Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Garrison, Sean (Norcross) Gesendet: Dienstag, 23. Dezember 2008 17:23 An: arslist@ARSLIST.ORG Betreff: New Discovery -- Shared Workflow can possibly cause performance degradation ** Just an fyi, I just discovered an issue in performance in Remedy. I have an active link that does a set fields to a dialog box on 'Instance id' = $Instance id$ that is shared among several forms. I am using the "Advanced" feature in the active link for the set fields and setting the server name = $SERVER$ and the form name = $SCHEMA$. I am then doing a set fields for "Matching Ids". What I noticed is that the API does a ARGetListEntry for every single field in the Schema to set the fields in the dialog which in turn will call all filters for "Get Entry" for every single field you have on the form. I found that it is faster to create a single active link for each form which will in turn only call the "Get Entry" filters once and will only retrieve all fields for the record once. The shared workflow still works so I feel bad calling it an issue but based on what I saw it would slow performance considerably. In my case removing the shared workflow shaved off 2.5 seconds off the load time of the form. Thanks, Sean Log examples (for the first 3 fields of a form): (Please forgive me ... I had to edit the log file to get it less than 1000 characters ....) Using Shared Workflow: <ACTL> 0: Set Fields <API > /* Tue Dec 23 2008 10:42:44.8419 */+GLSF ARGetListField -- schema CKFR:DM:PRD:PurchasedProduct <API > /* Tue Dec 23 2008 10:42:44.8423 */-GLSF OK <API > /* Tue Dec 23 2008 10:42:44.8483 */+GLSF ARGetListField -- schema CKFR:DM:PRD:PurchasedProduct changed since Wed Dec 31 19:00:00 1969 <API > /* Tue Dec 23 2008 10:42:44.8485 */-GLSF OK <API > /* Tue Dec 23 2008 10:42:44.8582 */+GLE ARGetListEntry -- schema CKFR:DM:PRD:PurchasedProduct <API > /* Tue Dec 23 2008 10:42:44.8604 */-GLE OK <API > /* Tue Dec 23 2008 10:42:44.8683 */+GE ARGetEntry -- schema CKFR:DM:PRD:PurchasedProduct entryId 000000000000141 <FLTR> /* Tue Dec 23 2008 10:42:44.8694 */Start filter processing -- Operation - GET <FLTR> CKFR:DM:PRD:PurchasedProduct - 000000000000141 <FLTR> Checking CKFR:DM:PRD:PurchasedProduct-on_GetEntry-SetContractedThrough-001 (500) <FLTR> --> Failed qualification <FLTR> /* Tue Dec 23 2008 10:42:44.8760 */ End of filter processing (phase 1) <FLTR> /* Tue Dec 23 2008 10:42:44.8760 */ Restart of filter processing (phase 3) <FLTR> > /* Tue Dec 23 2008 10:42:44.8760 */Stop filter processing <API > /* Tue Dec 23 2008 10:42:44.8762 */-GE OK <ACTL> Request ID (1) = 000000000000141 <API /* Tue Dec 23 2008 10:42:44.8797 */+GLE ARGetListEntry -- schema CKFR:DM:PRD:PurchasedProduct <API > /* Tue Dec 23 2008 10:42:44.8819 */-GLE OK <API > /* Tue Dec 23 2008 10:42:44.8882 */+GE ARGetEntry -- schema CKFR:DM:PRD:PurchasedProduct entryId 000000000000141 <FLTR> /* Tue Dec 23 2008 10:42:44.8895 */Start filter processing -- Operation - GET <FLTR> CKFR:DM:PRD:PurchasedProduct - 000000000000141 <FLTR> Checking CKFR:DM:PRD:PurchasedProduct-on_GetEntry-SetContractedThrough-001 (500) <FLTR> < --> Failed qualification <FLTR> /* Tue Dec 23 2008 10:42:44.8955 */ End of filter processing (phase 1) <FLTR> /* Tue Dec 23 2008 10:42:44.8955 */ Restart of filter processing (phase 3) <FLTR > /* Tue Dec 23 2008 10:42:44.8955 */Stop filter processing <API > /* Tue Dec 23 2008 10:42:44.8957 */-GE OK <ACTL> Submitter (2) = adunn <API /* Tue Dec 23 2008 10:42:44.8992 */+GLE ARGetListEntry -- schema CKFR:DM:PRD:PurchasedProduct <API > /* Tue Dec 23 2008 10:42:44.9014 */-GLE OK <API > /* Tue Dec 23 2008 10:42:44.9083 */+GE ARGetEntry -- schema CKFR:DM:PRD:PurchasedProduct entryId 000000000000141 <FLTR> /* Tue Dec 23 2008 10:42:44.9097 */Start filter processing -- Operation - GET <FLTR> CKFR:DM:PRD:PurchasedProduct - 000000000000141 <FLTR> Checking CKFR:DM:PRD:PurchasedProduct-on_GetEntry-SetContractedThrough-001 (500) <FLTR> --> Failed qualification <FLTR> /* Tue Dec 23 2008 10:42:44.9156 */ End of filter processing (phase 1) <FLTR> /* Tue Dec 23 2008 10:42:44.9156 */ Restart of filter processing (phase 3) <FLTR> /* Tue Dec 23 2008 10:42:44.9156 */Stop filter processing <API > /* Tue Dec 23 2008 10:42:44.9158 */-GE OK <ACTL> Create Date (3) = Friday, June 01, 2007 11:32:34 AM Using Regular Workflow (first 3 fields of the same form): <ACTL> 0: Set Fields <FLTR> Tue Dec 23 2008 10:19:48.1517 */Start filter processing -- Operation - GET <FLTR> CKFR:DM:PRD:PurchasedProduct - 000000000000141 <FLTR> Checking CKFR:DM:PRD:PurchasedProduct-on_GetEntry-SetContractedThrough-001 (500) <FLTR> --> Failed qualification <FLTR> /* Tue Dec 23 2008 10:19:48.1517 */ End of filter processing (phase 1) <FLTR> /* Tue Dec 23 2008 10:19:48.1518 */ Restart of filter processing (phase 3) <FLTR> /* Tue Dec 23 2008 10:19:48.1518 */Stop filter processing <API > /* Tue Dec 23 2008 10:19:48.1520 */-GE OK <API > /* Tue Dec 23 2008 10:19:48.1560 */+GMSF ARGetMultipleFields -- schema CKFR:DM:PRD:PurchasedProduct # of fields 1 from Remedy User (protocol 12) at IP address 10.138.7.136 <API > /* Tue Dec 23 2008 10:19:48.1563 */-GMSF OK <ACTL> Request ID (1) = 000000000000141 <ACTL> Submitter (2) = adunn <ACTL> Create Date (3) = Friday, June 01, 2007 11:32:34 AM __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
