Hi All, Thanks for the input guys. We noticed that the probem occured when we enabled "*Case Insensitive search*" for Oracle.
So we need to reindex the forms to get the good performance back. 'SW0032345' has the procedure to do it. Thanks. On Tue, May 19, 2009 at 2:42 PM, Lucero, Michelle < michelle.luc...@bankofamerica.com> wrote: > ** > > Hi, Kiran: > > > > I’m about 2 weeks behind on email, but didn’t want you to continue chasing > a ghost if you didn’t have to. This is a documented defect at least in 7.1 > Patch 2. Not sure if it was ever fixed. Obviously, you can check the usual > suspects by logging, etc. > > > > I ran into this issue on Mid-Tier when comparing version 6.3 P23, 7.0.1 P4 > and 7.1 P2. It appears that 6.3 P23 and 7.0.1P4 did NOT have the same > issue. The defect number is: SW00294698. > > > > Hope that helps, > > Michelle > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *LJ Longwing > *Sent:* Monday, May 11, 2009 8:28 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Slow to Switch between records in the search results list > > > > I would turn on API and SQL Logging before doing the switch and see if you > can see any delays in the logs > > > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *kiran kodali > *Sent:* Monday, May 11, 2009 7:12 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Slow to Switch between records in the search results list > > ** > > Hi All, > > > > It is taking much time to switch between records in the search results list > in user client. > > > > Did anybody experience the same problem? It happens even with the forms > having less data(500 records). > > > > Please let me know the parameters that would be affecting this dealy in > switching b/w records. Thanks. > > > > ARS 7.1 P006 > > Oracle 10G/Solaris > > > -- > Regards, > Kiran Kodali > Ph: 940-231-8524 > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the > Answers Are"_ -- Regards, Kiran Kodali Ph: 940-231-8524 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"