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