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)
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> Hi Honduras,
>
> Check Email Engine Error log form & Email Engine attachment form. How many
> records you have in there? Enable API/SQL/Filter logging & perform a
> search. It should give you some idea as where search is taking time.
>
> HTH
> ~M
>
> On Tue, Feb 12, 2013 at 10:26 AM, Walunjkar, Parshuram <
> [email protected]> wrote:
>
>> **
>>
>> Yes OOB 2 indexes are present.****
>>
>> Regarding search is slow can you please check API as well as SQL logs.****
>>
>> ****
>>
>> ** **
>>
>> The opinions, statements, and/or suggested courses of action expressed in
>> this E-mail do not necessarily reflect those of BMC Software, Inc. My
>> voluntary participation in this forum is not intended to convey a role as a
>> spokesperson, liaison or public relations representative for BMC Software,
>> Inc.****
>>
>> ** **
>>
>> ** **
>>
>> *From:* Action Request System discussion list(ARSList) [mailto:
>> [email protected]] *On Behalf Of *Drew Shuller
>> *Sent:* 11 February 2013 10:44
>> *To:* [email protected]
>> *Subject:* Email Messages Form Indexes?****
>>
>> ** **
>>
>> ** Good morning! Could anyone confirm what indexes are OOB on the Email
>> Messages form?
>>
>> AR Server 7.5 Patch 008, MS SQL 2008 DB
>>
>> The first index contains 7 colums: Mailbox ID, Message Type, Priority,
>> Send Message, Parse Message, Message ID and Execute/Send at. Is this OOB?
>>
>> The second index is one field, the Unique Identifier. The third one I just
>> created with one field, Create Date.
>>
>> There are 3500 records in that form and an unqualified search is taking
>> over 30 seconds. A search on create-date >= $DATE$ takes only slightly less
>> time.
>>
>> Drew
>> Honduras
>> _ARSlist: "Where the Answers Are" and have been for 20 years_ ****
>> _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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
