Slow load time of the Client List in HIFIS 4.0.60.2.1 when the Client List filter is set to Active or All.

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.