Peter Wilson

<p>This is a utility plugin for backporting a minor performance improvement scheduled for inclusion in WordPress 6.6 to earlier versions.</p>
<p>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.</p>
<p>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>.</p>
<p>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.</p>
<p>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.</p>


Performant Transients

Reduce the number of database calls querying transients.

Nazmul Hasan Robin

<p>🚀 <a href="https://github.com/nhrrob/nhrrob-options-table-manager" rel="nofollow ugc">GitHub Repository</a> – Found a bug or have a feature request? Let us know!<br />
💬 <a href="https://join.slack.com/t/nhrrob/shared_invite/zt-2m3nyrl1f-eKv7wwJzsiALcg0nY6~e0Q" rel="nofollow ugc">Slack Community</a> – Got questions or just want to chat? Come hang out with us on Slack!</p>
<p><span class="embed-youtube" style="text-align:center; display: block;"><iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/le89m1qfb0U?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe></span></p>
<p>Are you fed up with the size of wp otions table? You are not alone!<br />
Install this plugin and get a fine view of the table and analytics.</p>
<pre><code><?php echo 'Small WP Options Table, Clean Database!'; ?>
</code></pre>
<h3>🚀 A Powerful Yet Simple Solution to Manage wp_options</h3>
<p>Tired of an overloaded <code>wp_options</code> table slowing down your WordPress site? <strong>NHR Options Table Manager</strong> provides a clean, organized, and optimized way to view and manage your options table efficiently. Get detailed analytics, edit and delete options, and keep your database lean and performant.</p>
<h3>✨ Key Features</h3>
<ul>
<li><strong>Option History & Rollback</strong> – Track all changes to individual options and restore previous versions instantly.</li>
<li><strong>Autoload Health Check</strong> – Analyze total autoloaded data size and identify heavy options that slow down your site.</li>
<li><strong>Automated Daily Cleanup</strong> – Schedule automated daily deletion of expired transients via WP Cron.</li>
<li><strong>Scalable Tab Architecture</strong> – Unified interface that seamlessly supports third-party tables like Better Payment and WP Recipe Maker.</li>
<li><strong>Manage Options</strong> – Add, edit, and delete options easily using a secure, optimized modal system.</li>
<li><strong>Usermeta Table Support</strong> – Edit and delete user meta entries just like options.</li>
<li><strong>Serialized Data Handling</strong> – Edit serialized data seamlessly; it appears as a structured object or array.</li>
<li><strong>Options Usage Analytics</strong> – Get visual insights into which prefixes dominate your options table.</li>
<li><strong>Live Search & Pagination</strong> – High-performance DataTables with server-side processing.</li>
<li><strong>Security & Optimization</strong> – Protection for core WordPress options to prevent accidental data loss.</li>
<li><strong>Import / Export</strong> – Move settings between sites easily with JSON support.</li>
<li><strong>Global Search & Replace</strong> – Safely replace strings across the database with dry-run preview.</li>
<li><strong>Orphan Scanner</strong> – Find and clean up leftovers from uninstalled plugins.</li>
<li><strong>WP-CLI Support</strong> – Manage options (wp nhr-options list, wp nhr-options delete) from the command line.</li>
</ul>
<h3>🚀 Coming Soon</h3>
<p>We’re constantly improving NHR Options Table Manager! Here’s what’s on the way:<br />
– <strong>Scheduled Backups</strong> – Automatically backup your <code>wp_options</code> table before major changes.</p>
<h3>⚡ Easy Installation & Instant Setup</h3>
<p>No complex configurations needed! Just install, activate, and head to <strong>Tools <span aria-hidden="true" class="wp-exclude-emoji">→</span> Options Table</strong> for a detailed DataTable view of your options.</p>
<h3>🎯 Optimize Performance & Reduce Bloat</h3>
<p>Analyze, clean, and optimize your database by removing unnecessary options, improving site performance significantly.</p>
<h3>🌟 Join Thousands of Happy Users</h3>
<p>Get started today and take control of your WordPress options like never before!</p>


NHR Advanced Options Table Manager & Autoload Optimizer


Useful for exploring Options Table without entering into the database!


Useful Plugin


This plugin is super easy to use and does exactly what it promises. Clean interface, smooth performance, and really handy for managing options tables. Highly recommend!


Simple & Effective!

Optimize WordPress with Advanced Option History, Autoload Health Checks, and Automated Cleanup. Boost performance by reducing database bloat.

Performant Transients vs NHR Advanced Options Table Manager & Autoload Optimizer