We're using the Customer Support application which requires a contact record (and account) be associated with the issue. We allow the public to submit questions to us on the web site with a restricted read license so these generate accounts in the user form and contacts with all of the associated info for the issue. It works well since the agent has all of the customer information but it does end up creating a lot of extra accounts. We also pre-created 300K contacts when we first stood up the system for the most likely callers (out of about 1 million) so agents wouldn't have to create the contacts from scratch when they called. After about 3 years, we deleted those that were never used but we still have 240K based on those and new ones agents have created. Can you say "fetch-user-group-info-on demand" ? :o)
Well, I can confirm the -f option deletes the old content. Unfortunately, I made the mistake of trying to do groups and users at the same time and it messed up reloading the cache after clearing it and I had to use arcache to get back in. I've restarted by doing groups first (finishes fast) and I'm now doing users. It reads the whole user form first before clearing the cache so the wait time is based on the number of records in your user form and not the cached record count. Learn something new every day-guess it's all good and here is an example of where direct SQL updates can be problematic. It did give me a chance to purge all of the licenses while I was waiting... still waiting... still waiting... C.C., RSP ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ LongWing (Head) Sent: Friday, December 07, 2007 7:14 PM To: [email protected] Subject: Re: Urgent - user_cache about the only thing I can think of that would be uglier would be managing over 200K in user accounts...:) ________________________________ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
