Notifications

5 views

Description

When 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.

Cause

This was due to the exceptionally large "ts_word" table, which had 50,000,000+ records.

Resolution

It 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).

Article Information

Last Updated:2020-08-01 13:24:51
Published:2020-08-01