Client List time-out error | Voters

Client List time-out error

Ali Ryder

Winnipeg is having an issue testing 4.0.60.2.1 on their training database. They're getting a database table error when they load the Client List = All but not when they load the Client List = Active (and they say it takes a really long time).

April 5, 2024

Ryan Booker

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

Ali Ryder

Ryan Booker: That seems likely the problem. Have you reported this?

Ryan Booker

Ali Ryder yes, ticket 14559.