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=aolcmp00050000000003 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
