You are currently reviewing an older revision of this page.
User list slow when retrieving information.
The user list retrieves information back from the dms_audt table. When this table is larger it can slowness with the User list displaying in a timely manner.
Apply the attached index. The following is for SQL:
/* *********************************************************************************************-- -- This will add an index to the dms_audt table to help with a slow user list -- Author: Marty Nickel-- Date Created: 10/3/2012--************************************************************************************************/
CREATE NONCLUSTERED INDEX [index_dms_audt_slow_user_list] ON [dbo].[dms_audt] ( [o_objtype] ASC, [o_objno] ASC)INCLUDE ( [o_acttime]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
The following is for Oracle:
/* *********************************************************************************************-- -- This will add an index to the dms_audt table to help with a slow user list in Oracle --************************************************************************************************/
CREATE INDEX aa_custom_audit_1 ON pwise.dms_audt (o_objtype, o_action, o_objno, o_acttime) TABLESPACE PWISE_INDEX