Page MenuHomePhabricator

Allow the fulltext index to select only transactions with comments
ClosedPublic

Authored by epriestley on Sep 28 2017, 7:51 PM.
Tags
None
Referenced Files
Unknown Object (File)
Thu, Apr 11, 10:47 AM
Unknown Object (File)
Fri, Apr 5, 5:40 PM
Unknown Object (File)
Feb 21 2024, 5:01 AM
Unknown Object (File)
Feb 18 2024, 6:12 PM
Unknown Object (File)
Feb 15 2024, 10:23 PM
Unknown Object (File)
Feb 10 2024, 2:40 AM
Unknown Object (File)
Feb 6 2024, 11:34 AM
Unknown Object (File)
Jan 25 2024, 7:44 PM
Subscribers
None

Details

Summary

Ref T12997. Although we can't query by transaction type (since we can't easily enumerate all possible types which may have comments -- inline types may also have comments), we can just check if there's a comment row or not.

This reduces the amount of garbage we need to load to rebuild indexes for unusual objects with hundreds and hundreds of mentions.

Test Plan
  • Used batch editor to mention a task 700 times.
  • Indexed it before and after this change, saw index time drop from 1600ms160ms.
  • Made some new comments on it, verified that they still indexed/queried properly.
  • Browsed around, made normal transactions, made inline comments.
  • Added a unique word to an inline comment, indexed revision, searched for word, found revision.

Diff Detail

Repository
rP Phabricator
Lint
Lint Not Applicable
Unit
Tests Not Applicable

Event Timeline

This revision is now accepted and ready to land.Sep 28 2017, 7:54 PM
This revision was automatically updated to reflect the committed changes.
epriestley mentioned this in Unknown Object (Maniphest Task).Sep 28 2017, 7:57 PM