A notable performance increase can be seen while working with larger data sets if an index is created in the fuzzsearch_index table on the nid column.

CommentFileSizeAuthor
#1 nid-index-1209694-1.patch375 bytesjacobsanford

Comments

jacobsanford’s picture

jacobsanford
Primary language English
Location Fredericton 🇨🇦
commented
Status: Active » Needs review
StatusFileSize
new nid-index-1209694-1.patch375 bytes

Patch included. I believe the performance hit on record creation is small compared to the benefits from a column index.

kristen pol’s picture

kristen pol
she/her
Primary language English
Location Santa Cruz, CA, USA
commented

Here is a similar idea for Drupal 7: http://drupal.org/node/1760960#comment-7027406