I removed all the other forms from the active link. I only had the one form. In the first log I had the "Advanced" box checked, in the other log I didn't. I have already attached the results.
Conny -- Thanks for making me aware of the patch. Sean From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Tuesday, December 23, 2008 11:56 AM To: [email protected] Subject: Re: New Discovery -- Shared Workflow can possibly cause performance degradation ** I'm not sure if it would be a shared workflow issue or the fact that you are using the advanced workflow checkbox. As a test can you use your single active link (for a form) and use the advanced checkbox on it? Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Conny Martin Sent: Tuesday, December 23, 2008 10:30 AM To: [email protected] Subject: AW: New Discovery -- Shared Workflow can possibly cause performance degradation 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:[email protected]] Im Auftrag von Garrison, Sean (Norcross) Gesendet: Dienstag, 23. Dezember 2008 17:23 An: [email protected] 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"
