In ITSM 7.1 I have come across no known bugs with querying the CTM:People form from anywhere within the application, either through workflow, or other queries designed...
So the question is more about any customization that you may have done that may retrieve information from the CTM:People form to be set somewhere. Make sure that the searches that are issued on such customization, are using appropriate indexes, and if not, rebuild those qualifications if possible around existing indexes, or create new indexes as appropriate to support those queries.. Respect this one cardinal rule, and you should be ok.. Joe From: Mr. Tee Sent: Thursday, October 07, 2010 4:47 AM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: 4.6 million records in people form ** Hi ARSLIST, I am thinking about importing all customers (4.6 million) into Remedy (ITSM 7.1). The customers should not be users but only people. There will only be about 300 users and that is no problem. The Remedy applications and database is running on separate servers. The DB server is MS SQL 2005. Do anybody have any experience about setup and performance with this amount of records in the people form ? Lookup in ITSM applications (Customer on incident form, Requester on Change form etc) ? Thanks in advance. Kind regards Mr. Tee _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
