After running combined SQL and API logs, Misi's suggestion was the one that identified the problem. The Email Error Messages form has no indexes, so I added one for the Email Message ID, which is in one of the queries that I saw in the log file. Now even an unqualified search on the 3400 or so records runs very fast. Then I set the table property to false as suggested, just for good measure. And yes, there were a ton of records in the Email Error Messages form that are taking up space in the db. Those will be gone soon!
Thanks everyone for the help! Drew Shuller JTF-Bravo Honduras On Wed, Feb 13, 2013 at 2:16 AM, Misi Mladoniczky <m...@rrr.se> wrote: > Hi, > > The typical problem is too many records in the AR System Email Error Logs > form. > > You can see this if it takes time to flip between records after you have > performed the search. You can safely remove the refresh-on-entry-change for > the table field that loads the Error Logs data to save time. > > If you look at the indexes, and almost anything related to the AR System > Email > forms, you will see that the person who built them had next to no clue on > how > to build Remedy applications ;-) > > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"