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><iframe loading="lazy" title="S2E1 NHR Options Table Manager" width="750" height="563" src="https://www.youtube.com/embed/le89m1qfb0U?feature=oembed" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe></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>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>Better Payment Table Support</strong> – View and manage custom Better Payment data.</li>
<li><strong>Serialized Data Handling</strong> – Edit serialized data seamlessly; it appears as a structured object or array for easy modifications.</li>
<li><strong>Options Usage Analytics</strong> – Get insights into which prefixes dominate your options table.</li>
<li><strong>Live Search & Pagination</strong> – Search without reloading and navigate large datasets efficiently.</li>
<li><strong>Security & Optimization</strong> – Core options are protected, ensuring safe management of critical data.</li>
</ul>
<h3>🚀 Coming Soon</h3>
<p>We’re constantly improving NHR Options Table Manager! Here’s what’s on the way:<br />
– <strong>Bulk Deletion</strong> – Quickly remove multiple options and user meta entries at once.<br />
– <strong>WP Recipe Maker Table Support</strong> – Manage recipe-related data efficiently.<br />
– <strong>Expired Transient Deletion</strong> – Automatically clean up expired transients to free up database space.<br />
– <strong>More Exciting Features</strong> – Stay tuned for additional enhancements!</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 Options Table Manager


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!

Manage the wp_options table and get analytics on options usage.

Performant Transients vs NHR Options Table Manager