What is your RFE number? (AKA: If you want to "Vote" for this feature, then go submit an incident and request that it is converted to your own RFE for this feature. Since we can not actually see or vote on others RFE's. :)
My RFE for this is SW00254884. " Summary: improve Admin Tool "Related Workflow" tab display performance by adding indexes to object_search_ref form after sync process. Details: Development Performance gains can be made by adding two indexes to the object_search_ref from. Specifically: Index one: Target Identifier (Field ID 9001) AND Index two: Target Form (Field ID 9012) If these indexes could be removed at the beginning of a resync and re-established at the end then that would be even better. (But adding them in general would be a good thing IMHO.) " I seriously hope that the above request should take a day or two (of actual coding time) to implement. [ Now if they will actually do it... that is a different question. :] BTW: I did add the above indexes manually via the Admin tool. (v6.3, No problems. And the performance does seems better.) However, I do expect that the indexes will slow the "Sync" process while it is running. So it would be a good idea to: drop the indexes, do the sync and then recreate them. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 11/21/06, Carey Matthew Black <[EMAIL PROTECTED]> wrote:
Eric, Well done! Thanks for the through report and suggestions for other listers too. I am sure this will help others. Looks like two indexes should be added to these forms by BMC. (Time to go submit an RFE) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two.
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
