Thanks for the feedback LJ. I still need to go through the SQL logs to see if indexing can improve things, which is on my list to do but wanted to also reach out in parallel to the list in case others have already fought this.
I've attached the form of CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup to this message to show how horrific this is set up :). _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
