We have also experienced slow loading of the Client List in HIFIS 4.0.60.2.1 when the Client List filter is set to Active or All.

Active: ~ 58 seconds - 14,573 clients

All: ~ 100 seconds - 24,943 clients

Upon further investigation, the HIFIS application sends a query to the database for every client in the list to determine their racial identity. With thousands of clients appearing in the ‘Active’ and ‘All’ client lists, this adds significant delay to the loading of the client list.

The racial identity queries may not even be necessary as this information is not displayed anywhere in the Client List.

An example of the racial identity queries generated when loading the client list.

exec sp_executesql N'SELECT

[Extent1].[ClientRacialIdentityTypeID] AS [ClientRacialIdentityTypeID]

FROM [dbo].[HIFIS_Client_RacialIdentities] AS [Extent1]

INNER JOIN [dbo].[HIFIS_ClientRacialIdentityTypes] AS [Extent2] ON [Extent1].[ClientRacialIdentityTypeID] = [Extent2].[ID]

WHERE ([Extent1].[ClientID] = @p__linq__0) AND (''Y'' = [Extent2].[ActiveYN])',N'@p__linq__0 int',@p__linq__0=12345