Directory Database Indexes: Install New Updates
Link: https://support.brilliantdirectories.com/support/solutions/articles/12000109017
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 Directory Database Indexes Does
A database index is like the index at the back of a book: it lets the database jump straight to the rows it needs instead of reading every row in a table. This installer adds indexes to the core tables of your website's directory database so that common lookups, such as finding members, posts, and locations, run faster. Adding an index does not change the data stored in your tables in any way.
Specifically, the installer works from a fixed list of columns on these tables and adds a standard index to any listed column that does not have one yet:
- users_data (member accounts): columns such as email, first and last name, company, membership plan, location, and signup date
- data_posts (published posts and articles): columns such as category, title, status, author, publish and expiration dates, and location
- users_portfolio and users_portfolio_groups (member photo albums and media)
- users_meta (additional saved details about members and content)
- subscription_types (membership plans): columns used for search visibility and priority
- users_clicks (click statistics)
- location_cities and location_states (location lookup tables)
- lead_matches (matches between leads and members)
- bd_api_logs (API request logs)
Tables that do not exist on your site are skipped, and columns that are already indexed are left alone. The installer never modifies, deletes, or moves any rows; it only creates lookup structures alongside the existing data.
Why It Appears
The installer appears when at least one of the columns listed above exists in your database without an index. This is age related: websites created before these indexes became part of the standard platform setup may still be missing some of them, while newer sites already have them in place. If every listed column is already indexed, the installer does not appear and there is nothing to do.
Why It Matters
These tables sit behind the pages visitors use most. Member searches, post and article listings, location filtering, and profile pages all query them. Without indexes, the database has to scan entire tables to answer those queries, and that gets slower as your site accumulates more members and posts. With the indexes in place, those lookups go straight to the matching rows. To be clear about the magnitude: this improves query speed only. No features change and no content changes. Small sites may not notice a difference, while sites with many members or posts can see faster search and browse pages.
How to Run It
- From the admin dashboard, find the Install New Updates module and click Check For Updates.
- If your site has pending steps, Directory Database Indexes appears in the list. Click Install.
- After it completes, click Check For Updates again — the entry disappears once all steps are done.
If Directory Database Indexes 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 on your website looks different afterward and no content changes. Pages that search or filter members, posts, and locations may respond faster, which is most noticeable on sites with a large number of records. On very large tables, adding indexes can take a few moments to complete, so allow the install to finish before navigating away. Once it finishes, click Check For Updates again and the entry disappears. The change is safe, requires no follow-up, and there is nothing you need to verify or undo.
