While I agree that he should set it to 'take no action' it will never actually take that action because the qual will never have matching records....but I believe that Remedy has some code in place that will bypass the select if it is defined as you suggest
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Wednesday, December 05, 2007 9:46 AM To: [email protected] Subject: Re: Queries on a push field? ** Your problem is with the modify all matching. This push fields is to create a new entry with each submit not to modify all existing records which is what the modifying all matching is doing. -----Original Message----- From: Davies, J.T. <[EMAIL PROTECTED]> To: [email protected] Sent: Wed, 5 Dec 2007 11:40 am Subject: Queries on a push field? ** I was running some performance queries (inserting Panacea plug here ;)) and ran across a strange situation. Maybe someone's seen this before. Basically, a select query is being sent to the DB when a Push Fields action is being executed. The target for this push has 2.5 million rows (Help Desk Work Log...ugh). Every time a work log is submitted in the app, this push occurs along with this query. System: ARS 7.0.1 Patch 004 Solaris Oracle 10g I set up the following test situation: Regular source form: TestForm1 (no fields added...just core fields) Regular target form: TestForm2 (no fields added...just core fields) Filter: TestFilter Fires on Submit. No Run If qual. 1 action: Push Fields Push to TestForm2. Qual is: 1=2 (also tried with no qual...same result) Create ticket if no match Modify all matching Set matching ID's for push values Ran a filter/sql log. The following lines come up after the INSERT to the source table, but before the INSERT into the target table... SELECT T1614.C1,T1614.C1 FROM T1614 WHERE (1 = 2) ORDER BY 1 ASC and SELECT T1614.C1,T1614.C1 FROM T1614 ORDER BY 1 ASC respectively. Any ideas? Obviously, these are causing table scans...and against a table with 2.5 million rows...it gets a tad sluggish. Thought I'd query the group here prior to submitting to BMC... I probably wouldn't hear from them until after the new-year...even with our elevated level of support. Thanks! J.T. New Edge Networks An EarthLink Company __20060125_______________________This posting was submitted with HTML in it___ _____ More new features than ever. Check out the new AOL Mail <http://o.aolcdn.com/cdn.webmail.aol.com/mailtour/aol/en-us/text.htm?ncid=ao lcmp00050000000003> ! __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
