Drew,
With only 3500 records in a form, and if an unqualified search is taking that much time, you have a bigger problem than indexes in just that one form. If that form has only 3500 records, and is not expected to grow any larger than that, I wouldn't even care if there was not a single index on that form (although that's not a good practice). Take a SQL log when a search is performed on that form, and see what else gets triggered during that search. There may be Get List filters or other Active Link related workflow that might be triggered that is doing something far more than what meets your eye. Joe _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Drew Shuller Sent: Monday, February 11, 2013 12:14 PM 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
