Oh duh...thanks. I need to take an overdue vacation... (I even typed it out and didn't catch it!) :) Thanks J.T.
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Wednesday, December 05, 2007 8:46 AM To: [email protected] Subject: Re: Queries on a push field? ** Create ticket if no match Modify all matching If you want to always just do a Create set the If Any Match to "Take No Action" Setting it to Modify All Matching will update every single record. Fred ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Davies, J.T. Sent: Wednesday, December 05, 2007 10:41 AM To: [email protected] 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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
