Searching for an employee while creating HR case is taking long time to load the results (case creation page)DescriptionWhen the user was searching for an employee on the case creation page, it was taking a long time for employees to be returned in the results.CauseThis was due to the exceptionally large "ts_word" table, which had 50,000,000+ records.ResolutionIt was suggested that, as a result of the extremely large ts_word table, the user should revise their indexed tables, and disable the "Force partial search" checkbox in their case creation configuration.It was also recommended that the user create an Idea to add "startsWith" search to case creation (case creation uses text search - whereas something like a reference field uses startsWith).