You are currently reviewing an older revision of this page.
User list slow to come back
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. This will only work for SQL Servers, there have been no improvements shown with Oracle:
/* *********************************************************************************************-- -- 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]