Ok....so, have you turned on API/SQL/Filter logging into a single file and isolated the transaction to determine where the time is going?
On Tue, Jan 6, 2015 at 10:15 AM, Terry Bootsma <tboot...@objectpath.com> wrote: > ** > > For further information: > > Remedy User Tool against the join form: < 1 second > > MidTier direct access against the join form: < 5 seconds > > So, it is not a join-form or indexing issue. > > Terry > > > > > > > On 2015-01-06 12:12, tboot...@objectpath.com wrote: > > Hello everyone: > > I was wondering if anyone else has experienced this. > > > Environment: > > Red Hat Linux 6.4 > Mid Tier 8.1.01 SP1 20140514135 Hotfix > Apache Tomcat 6.0 > Remedy Server 8.1.01 201401281910 > Oracle Database > > When consuming web services that are based on "join" forms in Remedy, we > have experienced a significant performance degradation in response time. > For example, to query 2000 rows in the base form with a web service against > the base form, < 3 seconds. If we create a self-join and do the same web > service .. approx 17 seconds. > > Has anyone else seen this? > > Thanks. > > Terry > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"