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

["Ate Douma (JIRA)" <je...@portals.apache.org>]

     [ http://issues.apache.org/jira/browse/JS2-324?page=all ]

Ate Douma updated JS2-324:
--------------------------

    Version: 2.0-POST
                 (was: 2.0-M2)

Forgot to set the Fix Version to 2.0-FINAL

> Missing index from db(oracle) causes userManagement portlets stop working when lots of users in system
> ------------------------------------------------------------------------------------------------------
>
>          Key: JS2-324
>          URL: http://issues.apache.org/jira/browse/JS2-324
>      Project: Jetspeed 2
>         Type: Bug
>     Versions: 2.0-POST
>  Environment: Linux
>     Reporter: Teijo Lallukka
>     Priority: Minor

>
> 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) 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org