Product(s):	ProjectWise Integration Server
	Version(s):	08.11.11.559
	Area:	Integration / Caching /Gateway
	Subarea:	MISC
	Original Author:	Marty Nickel, Bentley Technical Support Group

Problem Description

User list slow when retrieving information.

Reason

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.

Steps to Resolve

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