Peter Wilson

This is a utility plugin for backporting a minor performance improvement scheduled for inclusion in WordPress 6.6 to earlier versions.
In WordPress 6.4 the function <code>wp_prime_option_caches()</code> was introduced to allow for multiple options to be queried in a single database call.
On sites without a persistent cache, temporary transients are stored in two options. One containing the transient itself, the other containing the timeout. These are stored as <code>_transient_[transient name]</code> and <code>_transient_timeout_[transient name]</code>.
In WordPress 6.6 and later, these options are primed by a single database call using the priming function. This plugin can be used on WordPress 6.4 and 6.5 to backport the functionality.
While a mild improvement on sites making limited use of transients, this can significantly reduce the number of database queries on sites running plugins making heavy use of transients.

Performant Transients

Reduce the number of database calls querying transients.

SAC Database Inspector is a lightweight, admin-only utility designed to help site administrators understand what is stored in their site’s database and cache — and clean it up safely when needed.
Unlike aggressive “optimizer” plugins, Database Inspector focuses on visibility first, showing you where bloat exists before offering optional, manual cleanup actions.
<h3>Key features:</h3>
<ul>
<li>Database health gauge with clear visual feedback</li>
<li>View total database size (when supported by hosting)</li>
<li>Inspect autoloaded options that load on every page</li>
<li>Identify expired and unused transients</li>
<li>Detect post revisions, auto-drafts, spam, and trash</li>
<li>Find orphaned post meta and comment meta</li>
<li>Flush external object cache (when enabled)</li>
<li>Optional read-only mode via filter for audit-only environments</li>
<li>Multisite-aware and shared-host safe</li>
<li>No frontend impact — admin-only</li>
<li>Contextual source identification for autoloaded options</li>
</ul>
All cleanup actions require explicit confirmation and are protected by nonces and capability checks.
<h3>Developer Notes</h3>
This plugin follows coding standards and avoids aggressive optimization tactics. It is intended as a transparent inspection and maintenance tool, not an automatic optimizer.
Filters and actions are provided for extensibility.

SAC Database Inspector

Inspect database usage, autoloaded options, transients, and safely clean database clutter from a single admin dashboard.

Performant Transients vs SAC Database Inspector