Hi Ars Team, I have run the arlogtimer utility, and observed that the Execution times in API is above 4 seconds for all the transactions.
However, the execution times in SQL is maximum 1 second. I think it indicates that there is no need to perform indexes, but there is a need to check the workflow and maybe archive data. Please do share your thoughts. Thank you, Regards, Sonia _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

