How would you expect a performance degradation on this issue? A record is saved. ARS must query its filters / cache for filters on that form. If a filter is used in multiple forms, it cannot make a performance difference as only the set of filters for that one form is looked at.
So, if you do what you plan and run a performance test, I expect zero performance changes whether the set of filters is shared by one form or 500 forms. A good way (in general, not related to your query) to increase filter performance is to NOT have filter qualifications evaluated at all by coding them up in filter guides and implementing branches (gotos) within that guide. Filters in guides have no firing conditions and are not looked at until the guide itself is fired. Then appropriate branching within that guide can eliminate condition evaluation of filters in that guide. Cheers Ben -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Louise van Hine Sent: July 7, 2009 2:38 PM To: arslist@ARSLIST.ORG Subject: Re: logic limit on shared workflow? Sorry I wasn't clear, I am concerned about whether there is a performance degradation or a hard limit on the number of forms that can be attached/share a group of 120 links and about 20 filters, and you've answered the part about number of forms, now the only concern is whether the same workflow shared by 50 forms causes a significant decrease in performance. Thanks! Axton Grams wrote: > > Logical Limits: > - number of groups in the assignee group field > - length of a username/group > - joins: unions, aggregates, inline functions > - functions in qualifications > - number of actions in a workflow object's if/else > - number of optional/required fields on a form > - size of an integer > - date/time field after 2038 > - number of filters in a single operation, though the limit can be > changed > - duration the arserver waits on the db server to return > - A regular form can only handle 999,999,999,999,999 entries > > The list can go on for a long time. Anything in particular you are > worried about? > > As for shared workflow, the data model used in the meta-data tables is > capable of accommodating any number of forms per workflow object. > > Axton Grams > > This reflects my opinions and observations. > > On Mon, Jul 6, 2009 at 10:56 AM, Louise van > Hine<lvanh...@express-scripts.com> wrote: >> Has anyone ever run into a logical or performance limit on shared >> workflow? >> The sizing I am talking about is 150 objects (mostly active links, a >> few AL guides and a couple of dozen filters), and 75 forms. Most of >> the workflow consists of shared buttons and screen control, the >> filters do mainly creates and a few modifies to subforms. >> >> I did see an earlier message on the list regarding the use of >> $SERVER$ and $SCHEMA$ keywords in AL actions slowing down the server, >> but are there other logical limits that anyone knows about? >> >> Platform ARS 7.0.01 Patch 7 >> >> >> Thanks! >> >> >> -- >> View this message in context: >> http://www.nabble.com/logic-limit-on-shared-workflow--tp24358132p2435 >> 8132.html Sent from the ARS (Action Request System) mailing list >> archive at Nabble.com. >> >> _____________________________________________________________________ >> __________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers >> Are" >> > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > -- View this message in context: http://www.nabble.com/logic-limit-on-shared-workflow--tp24358132p24372522.ht ml Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
