Search Results Cache System: Install New Updates

Link: https://support.brilliantdirectories.com/support/solutions/articles/12000109019

The Install New Updates module on the admin dashboard lists one-time platform installers that have pending steps for your specific website. Click the green Check For Updates button to refresh the list — an installer only appears when your site actually has something left to install, and it disappears from the list once its steps are complete.

What Search Results Cache System Does

This installer tunes four existing database tables so the platform can quickly and reliably tell when their contents last changed. That change tracking is what the platform's search results caching relies on. It makes two kinds of adjustments:

• Adds database indexes to the last-modified timestamp columns of four tables: the modtime column of users_data (your member data), and the revision_timestamp columns of data_categories (your directory categories), subscription_types (your membership plans), and website_design_settings (your design settings). An index lets the database check these timestamps quickly instead of scanning entire tables.
• Makes those timestamps keep themselves current. It adjusts the definition of those same four columns so the database automatically refreshes the timestamp whenever a row is edited (in database terms, ON UPDATE CURRENT_TIMESTAMP). From then on, the last-modified time stays accurate on its own.

Only table definitions are changed. The installer does not edit, delete, or move any of the member records, categories, membership plans, or design settings stored in those tables.

Why It Appears

It appears when at least one of those four timestamp columns is missing its index, or when at least one of them is not yet set to refresh automatically when a row changes. This is an age-related condition: databases created before these column definitions became the platform standard will not have them yet, which is normal for older sites. Each step inspects the actual table definitions in your database and only offers to run when something is missing.

Why It Matters

Caching search results only works well if the platform can cheaply answer one question: has any of the underlying data changed since the cached results were saved? The four tables this installer touches hold member data, categories, membership plans, and design settings. With indexed, self-updating last-modified timestamps, that freshness check becomes a fast lookup. To be clear about the magnitude: this is a performance and reliability improvement behind the scenes. It does not change what appears in your search results, only how efficiently the platform can keep cached results current.

How to Run It

1. From the admin dashboard, find the Install New Updates module and click Check For Updates.
2. If your site has pending steps, Search Results Cache System appears in the list. Click Install.
3. After it completes, click Check For Updates again — the entry disappears once all steps are done.

If Search Results Cache System does not appear in the list, your website is already up to date — the module only shows installers with pending steps, so there is nothing to do.

After Running

Nothing changes visibly on your website, and all of the data in those four tables remains exactly as it was. Going forward, the last-modified timestamps on member data, categories, membership plans, and design settings refresh automatically whenever those records are edited. There is nothing to verify or configure; if you want confirmation, click Check For Updates again and the entry will be gone. The update simply brings your tables in line with the current platform standard, so there is nothing you would need to undo.