A client found after using SSS for 6 months that the search slowed down. A table rebuild fixed this.
To head this off, add an automated table rebuild which runs every week on a sunday by default to perform the table rebuild but EXCLUDING the suggestions rebuild. (i.e. the regular rebuild should run as if SSS_FORCE_SUGGESTIONS_REBUILD was set to false)
Add an option to the main tab for the regular rebuild, let them choose the day, time and then every X weeks (1,2,3,4,5,6,7,8,9,10,11,12) - DO NOT ADD A CRON SCHEDULE
also let them enable/disable the scheduled rebuild
Schedule a single cron event for the next time, default should be Sunday, 5AM, every 4 weeks.
In the cron, have it call the function to perform the rebuild (this spawns another cron) but make sure whatever option is passed to it to make it not run the suggestions rebuild. At the end of the cron, schedule another single event for X weeks in future, i.e. don't use cron schedule - cron schedule is for daily/every hour etc - this cron event can just be a single event.
If the schedule option is changed in sss settings, clear any existing single event and schedule the new one.
A client found after using SSS for 6 months that the search slowed down. A table rebuild fixed this.
To head this off, add an automated table rebuild which runs every week on a sunday by default to perform the table rebuild but EXCLUDING the suggestions rebuild. (i.e. the regular rebuild should run as if SSS_FORCE_SUGGESTIONS_REBUILD was set to false)