Vikram, Now that I have let the 3 lac replies asking about lac pass.... On to your question!
We have a number of customers with large numbers of groups. We have systems with 100,000 groups on them. As to performance.... Correctly configured and used, there is no problem. Incorrectly, and there are big problems. It is important that the vast majority (say 199,900 of 200,000 groups) are of group type None. This makes them groups that can be used to collect people and be used for row level security, but are not used to assign View/Change rights directly. If you have 1000s or more of groups that have View/Change type, it is very much of an impact in terms of computing group rights and in Dev Studio of having massive lists of groups when you are trying to assign permissions to objects. So, incorrectly configured (View/Change for every group) is a problem but properly configured (None for almost all with just a few having View/Change designations) it is fine. The second area where there are issues is any area where you try and get a list of groups. If you do that in an uncontrolled way, you get a BIG return set and it may be a signifiant performance issue. For example, in the ITSM solution, there is a menu on Group fields on the forms and if you have 100,000 groups, you get a menu with 100,000 entries -- a bit of a challenge. If you however use qualified menus or auto-completion and you require at least 3 or 5 letters before trying to auto-complete, everything is just fine. (by the way, the ITSM solution is reworking to make sure the menu of groups where there are lots of groups is not an issue in the future) But either way here, there is no overall system performance issue, it is just a response time issue trying to use that menu with many items. So, build your groups right And, build your menus (or any other access to a list of groups) right and there is no problem with having a large number of groups. I hope this is useful, Doug Mueller -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Vikram Sent: Tuesday, August 09, 2011 11:36 PM To: [email protected] Subject: Huge Number of Groups in Group form... is it a good idea??? hi all, Well we have a situation where we need to create about 2 lac groups in our group form each group having about 10 users. yes the number is huge but they are not concurrent users. The system we are talking about is a home grown system with 3 servers in server group with ARS 7.5 and remote oracle 10g on solaris with 20+ Gigs of Ram. The 2 lac groups we need to create are nothing but customers companies and users in them are nothing but customer contacts. This activity is to be done so that we have a systematic access control in place. In a nut shell every customer is an independent entity and cannot see tickets and other details from other companies. Yes this sounds like ITSM multitenancy but just that we dont have ITSM installed as its complete customized system. So the thing we are worried about is the performance of the system if we create about 2 lac groups in the groups form. Whats the worst thing and not so worst thing that I can expect. Or if anyone of you experts can suggest a new way for the same will be appreciated? Thanks in advance, Vikram _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
