Does the form have one or more tables on it that pull in data from other forms (or even the same form)? If so, make sure that the form it is pulling data from has an index that covers the qualification the table uses to pull data. I've also seen it take a long time where there is workflow configured to iterate over the rows in the table, and the processing took a while.
That's just one possibility. I would agree with the logging. I would also turn on Active Link logging. Lyle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ Longwing Sent: Monday, May 11, 2009 7:28 AM To: [email protected] 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:[email protected]] On Behalf Of kiran kodali Sent: Monday, May 11, 2009 7:12 AM To: [email protected] 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: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
