We have a few reports that have to pull street, city, state, and zip from Person Address and these reports take an extreme amount of time to complete. We have tried filtering address by various address rules that are setup with minimal success. Has anyone encountered anything similar when attempting to pull address information or know of any tips and tricks to pull address in a timely fashion. Thanks...
Quote from: jb2321 on 20 Oct 2011 10:17:54 AM
We have a few reports that have to pull street, city, state, and zip from Person Address and these reports take an extreme amount of time to complete. We have tried filtering address by various address rules that are setup with minimal success. Has anyone encountered anything similar when attempting to pull address information or know of any tips and tricks to pull address in a timely fashion. Thanks...
Person Address?
Are you refering to a certain table? Did you check whether query-time is excessive? Are you explicitly sorting the data by to many levels?
Hard to give any advice without a lot more specific details..