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"
