Idea submitted... Review Email Engine form(s) indexing and adjust as appropriate <https://communities.bmc.com/communities/ideas/1758>
Jason On Wed, Feb 13, 2013 at 9:44 AM, Drew Shuller <[email protected]>wrote: > ** 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 <[email protected]> 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) >> >> _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"
