[JS2-324] Missing index from db(oracle) causes userManagement portlets stop working when lots of users in system

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.1
• Fix Version/s: 2.2.0
• Environment: Linux
• Assignee: Unassigned
• Reporter: Teijo Lallukka
• Created: 10/Aug/05 05:47
• Updated: 04/Oct/11 21:07
• Resolved: 07/Oct/08 23:57

Description

I bulk loaded 500 users to jetspeed and noticed that management portlets(add user, add user to group and so on) don't work any more.
I found out that queries to db are slow and creation of one index is good workaround. I haven't tested latest version that will it be fixed there.

Workaround: create index SECURITY_CREDENTIAL_PRINID_IDX on SECURITY_CREDENTIAL (PRINCIPAL_ID)