Ok ... So it is not the fact it was workflow shared on multiple forms, it is because you used the Advanced option that caused the system to pull 1 field at a time.
Good info to watch out for as I used workflow shared on multiple form as much as possible, but I have not had to use the Advanced option. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Garrison, Sean (Norcross) Sent: Tuesday, December 23, 2008 11:37 AM To: arslist@ARSLIST.ORG Subject: Re: New Discovery -- Shared Workflow can possibly cause performance degradation 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. Sean ________________________________ 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
