Michael, I have wondered that aloud too.. Its always been that way..
Even the Login Name does not have a unique index on it in the user form... At least they put a simple index on it.. If I remember right, version 6.x didn't even have that simple index on it.. causing applications like customer support crawl on user form searches if you had close to a million customers.. I asked support about it once and didn't get a good answer as to why an index is missing on that form.. now it looks like they have an index on the Login Name for version 7 but its not unique.. In my experience it doesn't hurt to put those indexes yourself. I've always done it (both on the group and user form) with no negative effects - in fact it helped one of my customers quite a bit on the performance side after introducing those indexes as required.. Some parts of their system was virtually unusable before doing that.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Durrant, Michael M. - ITSD Sent: Wednesday, January 09, 2008 4:11 PM To: arslist@ARSLIST.ORG Subject: ARS 7.x: No unique index on Group ID? ** I did an application export/import from development to production and it replicated our existing Group IDs. Why is there no unique index on Group ID? I can't fathom a situation where I would want differently named groups with the same ID. Am I totally off-base on this or ??? Thanks, Michael No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.0/1216 - Release Date: 1/9/2008 10:16 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
