Advanced Database Cleaner – Optimize & Clean Database to Speed Up Site Performance vs W3 Total Cache

Advanced Database Cleaner is a complete WordPress optimization plugin that helps you clean up database clutter and optimize database performance by removing unused data such as old revisions, auto drafts, spam comments, expired transients, unused post meta, duplicated post meta, unused user meta, etc. It is designed to help you improve website speed by reducing database bloat and ensuring a lean, efficient WordPress installation. It also provides detailed previews, powerful filters, and automation tools to safely control what gets cleaned. With the ✨Premium version✨, you can unlock even more advanced features, such as detecting and cleaning orphaned options, orphaned tables, orphaned post meta, orphaned user meta, orphaned transients, and orphaned cron jobs. It also gives you clear insights into how your database evolves over time through built-in analytics, lets you monitor plugin and theme activity to better understand when new data is created or when leftovers appear, and much more. Why use Advanced Database Cleaner❓ 👉 Get a clear overview: see how many tables, options, transients, cron jobs, metadata… records you have, and identify which are unused or orphaned. 👉 Save time: configure what to clean, how far back to keep data, and how often to run automations. The plugin will then handle recurring cleanups for you. 👉 Save space and improve performance: removing unnecessary data reduces database size, makes backups faster, and can improve query performance, especially on busy or older sites. ✅ Main Features Delete old revisions of posts and pages Delete old auto-drafts Delete trashed posts Delete pending comments Delete spam comments Delete trashed comments Delete pingbacks Delete trackbacks Delete unused post meta Delete unused comment meta Delete unused user meta Delete unused term meta Delete unused relationships Delete expired transients Delete duplicated post meta Delete duplicated user meta Delete duplicated comment meta Delete duplicated term meta Delete oEmbed caches Display the database size that will be freed before cleaning for each item type, and the total size to be freed Display and preview items to clean before performing a database cleanup to ensure safety Sorting capability in cleanup preview tables (by name, date, size, site id, etc.) View options value content in original or formatted mode for serialized or JSON structures (and other items types as well). Keep last X days of data: clean only data older than the number of days you specify ✅ Automation Schedule database cleanup to run automatically Create scheduled cleanup tasks and specify which items each task should clean Schedule database optimization and/or repair to run automatically Execute scheduled tasks based on several frequencies: once, hourly, twice a day, daily, weekly, or monthly Specify the “keep last X days” rule for each item type in a scheduled task Pause/Resume scheduled tasks whenever needed Create as many scheduled cleanup tasks as needed and specify what each task should clean ✅ Tables Display the list of database tables with information such as number of rows, table size, engine, etc. Sort tables by any column such as table name or table size Display table contents along with their column structure, indexes, status, and more Detect and filter tables with invalid prefixes (tables that do not belong to the current WordPress installation), this can be enabled or disabled from the settings page Optimize database tables (the plugin notifies you when tables require optimization) Repair corrupted or damaged database tables (the plugin notifies you when tables are corrupted) Convert tables to InnoDB for better performance Empty rows of database tables Clean and delete database tables ✅ Options Display the options list with information such as option name, option value, option size, and autoload status Sort options by any column such as option name or option size View option value content in original or formatted mode for serialized or JSON structures. Notify you if autoloaded options are large and help reduce autoload size for better performance Detect large options that may slow down your website Set option autoload to yes/no Clean and delete options ✅ Cron Jobs Display the list of active cron jobs (scheduled tasks) with information such as arguments, action, next run, schedule, etc. Sort cron jobs by any column such as action name or next run time Detect cron jobs with no valid actions Clean and delete scheduled tasks ✅ Post Meta Display the post meta list with information such as meta key, value, size, associated post ID, etc. Sort post meta by any column such as meta key, meta size, or post ID View post meta value content in original or formatted mode for serialized or JSON structures. Detect unused post meta (meta not associated with any existing posts) Detect duplicated post meta (same meta key/value for the same post ID) Clean and delete post meta ✅ Post types Display post types with information such as name, post count, visibility (public or non-public), etc. Sort post types by columns such as name, post count, visibility, etc. View posts corresponding to each post type, along with their details Detect unused or orphaned post types Clean orphaned post types ✅ User Meta Display the user meta list with information such as meta key, value, size, associated user ID, etc. Sort user meta by any column such as meta key, meta size, or user ID View user meta value content in original or formatted mode for serialized or JSON structures. Detect unused user meta (meta not associated with any existing users) Detect duplicated user meta (same meta key/value for the same user ID) Clean and delete user meta ✅ Transients Display the list of transients with information such as name, value, size, and expiration time Sort transients by any column such as transient name, size, or expiration time View transient value content in original or formatted mode for serialized or JSON structures. Clean expired transients Detect large transients that may slow down your website Clean and delete transients Set transient autoload to yes/no ✅ WooCommerce Clean orphaned product variations Clean orphaned customer analytics Clean expired customer sessions ✅ Other Tools Display current database size Logging system for easy troubleshooting Access the WordPress debug log directly from the plugin interface Multisite support (network-wide database cleanup and optimization from the main site) Modern, responsive interface powered by React for a smooth experience without page reloads Show/hide plugin tabs for better usability ⚡ Premium Features ⚡ Official website Unlock the full power of database cleanup and optimization with Advanced Database Cleaner Premium – packed with smart features that take accuracy, speed, and cleanup control to the next level. ✅ Remote SmartScan Local scan + Remote SmartScan technology to accurately detect the true owners of tables, options, post meta, user meta, transients, and cron jobs Cloud-enhanced ownership detection using a large and continuously improving remote database Improved accuracy for identifying orphaned items left by deleted plugins and themes Ability to edit ownership of any item and correct misidentified owners Ability to send ownership corrections to improve the global detection database Enhanced “Belongs to” ownership column everywhere using cloud data + local data Display multiple possible owners for each item when applicable Display owner status (active, inactive, not installed) to simplify cleanup decisions Check your remote scan credits to monitor usage ✅ Action Scheduler Cleanup Clean Action Scheduler Completed actions Clean Action Scheduler Failed actions Clean Action Scheduler Canceled actions Clean Action Scheduler Completed logs Clean Action Scheduler Failed logs Clean Action Scheduler Canceled logs Clean Action Scheduler Orphan logs ✅ General Cleanup Enhancements Keep last X items feature in General Cleanup Keep last X items per parent (e.g., per post) Keep last X items globally (e.g., keep the last 10 pingbacks) Combine Keep Last X Days with Keep Last X Items for advanced cleanup safety ✅ Advanced Filters Advanced filters in all modules (Tables, Options, Post Meta, User Meta, Transients, Cron Jobs) Filter by size, value content, autoload, expiration, metadata type, and more Filter by plugin owner, theme owner, WordPress core, orphan, or unknown Filter by multisite site ID with full per-site visibility Filter by action frequency and interval in cron jobs Filter by duplicated, unused, large, not-yet-scanned, or expired items ✅ Advanced Automation Unlimited automation tasks (Free version is limited to 5 tasks) Create any number of scheduled cleanup tasks with different configurations Create scheduled optimization and repair tasks Use Keep Last X Items and Keep Last X Days inside scheduled tasks Run automation tasks hourly, twice daily, daily, weekly, monthly, or at any supported frequency Pause/resume/delete automation tasks without losing settings Per-task automation event logging showing executed actions, number of items cleaned, execution timestamps, and detailed logs ✅ Database Analytics Daily tracking of total database size and number of tables Daily and monthly charts showing database growth trends Raw data tab with all recorded measurements Table-level analytics showing size growth, rows growth, and daily changes Ability to detect abnormal table growth caused by logs, caches, or runaway actions Multi-table selection and search for analyzing multiple tables at once ✅ Addons Activity Automatically track plugin activations, deactivations, and uninstalls Automatically track theme switches and uninstalls Display activity in a color-coded timeline for better readability All timestamps shown in your local timezone Multisite support (activity recorded on the main site) ✅ Full Multisite Support Clean any site or all sites Filter items by site ID in every module (Tables, Options, Post Meta, User Meta, Transients, Cron Jobs) Display which site each item belongs to Run automation tasks across the entire network 🛒 WOptimize – The Cleaner & Optimizer for WooCommerce If you run a WooCommerce store and want to go further, try our dedicated plugin WOptimize – the ultimate solution to clean and speed up your WooCommerce store. Learn more: https://sigmaplugin.com/downloads/woptimize

W3 Total Cache (W3TC) improves the SEO, Core Web Vitals and overall user experience of your site by increasing website performance and reducing load times by leveraging features like content delivery network (CDN) integration and the latest best practices. W3TC is the only web host agnostic Web Performance Optimization (WPO) framework for WordPress trusted by millions of publishers, web developers, and web hosts worldwide for more than a decade. It is the total performance solution for optimizing WordPress Websites. BENEFITS Improvements in search engine result page rankings, especially for mobile-friendly websites and sites that use SSL At least 10x improvement in overall site performance (Grade A in WebPagetest or significant Google PageSpeed improvements) when fully configured Improved conversion rates and “site performance” which affect your site’s rank on Google.com “Instant” repeat page views: browser caching Optimized progressive render: pages start rendering quickly and can be interacted with more quickly Reduced page load time: increased visitor time on site; visitors view more pages Improved web server performance; sustain high traffic periods Up to 80% bandwidth savings when you minify HTML, minify CSS and minify JS files. KEY FEATURES Compatible with shared hosting, virtual private / dedicated servers and dedicated servers / clusters Transparent content delivery network (CDN) management with Media Library, theme files and WordPress itself Mobile support: respective caching of pages by referrer or groups of user agents including theme switching for groups of referrers or user agents Accelerated Mobile Pages (AMP) support Secure Socket Layer (SSL/TLS) support Caching of (minified and compressed) pages and posts in memory or on disk or on (FSD) CDN (by user agent group) Caching of (minified and compressed) CSS and JavaScript in memory, on disk or on CDN Caching of feeds (site, categories, tags, comments, search results) in memory or on disk or on CDN Caching of search results pages (i.e., URIs with query string variables) in memory or on disk Caching of database objects in memory or on disk Caching of objects in memory or on disk Caching of fragments in memory or on disk Caching methods include local Disk, Redis, Memcached, APC, APCu, eAccelerator, XCache, and WinCache Minify CSS, Minify JavaScript and Minify HTML with granular control Minification of posts and pages and RSS feeds Minification of inline, embedded or 3rd party JavaScript with automated updates to assets Minification of inline, embedded or 3rd party CSS with automated updates to assets Defer non-critical CSS and JavaScript for rendering pages faster than ever before Defer offscreen images using Lazy Load to improve the user experience Browser caching using cache-control, future expire headers and entity tags (ETag) with “cache-busting” JavaScript grouping by template (home page, post page etc) with embed location control Non-blocking JavaScript embedding Import post attachments directly into the Media Library (and CDN) Leverage our multiple CDN integrations to optimize images WP-CLI support for cache purging, query string updating and more Various security features to help ensure website safety Caching statistics for performance insights of any enabled feature Extension framework for customization or extensibility for Cloudflare, WPML and much more Reverse proxy integration via Nginx or Varnish Image Converter extension provides modern image format conversion (e.g., WebP, AVIF) from common image formats (on upload and on demand) W3 Total Cache Pro Features With over a million active installs, W3 Total Cache is the most comprehensive WordPress caching plugin available and has robust premium features that help deliver an exceptional user experience. Full Site Delivery: Serve your entire site from a Content Delivery Network (CDN), ensuring faster load times worldwide. Fragment Cache: Optimize the caching of dynamic content while still improving performance. REST API Caching: Speed up your headless WordPress site by caching REST API calls. Eliminate Render-Blocking CSS: Ensure your CSS doesn’t hold up page loading, providing faster initial paint. Delay Scripts: Improve performance by delaying the loading of non-essential scripts until they are needed. Preload Requests: Boost page performance by preloading critical resources before they’re requested. Remove CSS/JS: Clean up unnecessary CSS and JavaScript files that slow down your pages. Lazy Load Google Maps: Load Google Maps only when it’s visible, reducing unnecessary requests. WPML Extension: Optimize performance on multilingual sites powered by WPML. Caching Statistics: Get detailed insights on cache usage and performance improvements. Purge Logs: Keep your site clean by automatically purging unnecessary cache logs. 30-Day Money-Back Guarantee Try W3 Total Cache Pro risk-free with our 30-day money-back guarantee. If you’re not satisfied, we will refund your purchase. PAGESPEED SCORE IMPROVEMENTS To help you understand the impact of individual features on your website’s performance, we’ve tested each feature separately to see its effect on Google PageSpeed scores. While optimal results come from configuring several different caching tools together, the following individual features also show significant improvements on their own: Remove Unused CSS/JS This feature removes CSS and JavaScript files that are not needed for the current page, reducing the load time. Added over 27 points to the Google PageSpeed score (Before: 57.2 / After: 86.7) Reduced the Potential Savings From Unused JavaScript from 127.5 KiB to 84 KiB View the test results Full Site Delivery Full Site Delivery optimizes the delivery of your entire site, enhancing the server response time. Added a 99% performance enhancement to the Average Server Response Time (Before: 3413 ms / After: 34 ms) View the test results Eliminate Render Blocking CSS This feature eliminates CSS that blocks the rendering of your page, speeding up the initial load time. Added over 17 points to the Google PageSpeed score (Before: 53.75 / After: 71) Reduced the Potential Savings From Render-Blocking Resources by over 94% (Before: 2432.5 ms / After: 125 ms) Improved the Largest Contentful Paint time by over 56% (Before: 7s / After: 3.04s) View the test results Delay Scripts Delay Scripts postpones the loading of certain scripts until they are needed, reducing initial load times. Added 14 points to the Google PageSpeed Performance score (Before: 54.25 / After: 68.5) Reduced the Time Third-Party Code Blocked The Main Thread For by 62% (Before: 825 ms / After: 197.5 ms) View the test results Rest API Caching This feature caches API responses, reducing server load and speeding up API interactions. Reduced the Average Server Load by 40% (Before: 0.62 / After: 0.37) Sped up API Responses by 84.5% (Before: 968ms / After: 150ms) Reduced the Average Server Load by 24% under during a major traffic spike (Before: 34.55 / After: 26.19) View the test results Modern Image Formats Converts images to modern formats like WebP or AVIF, which are more efficient and faster to load. Added over 9 points to the Google PageSpeed score (Before: 84.67 / After: 93.83) View the test results Lazy Load Google Maps Delays the loading of Google Maps until the user interacts with them, reducing initial load time. Added 10 points to the Google PageSpeed score (Before: 66 / After: 76) Reduced the Total Blocking Time Performance score by 72% (Before: 287.5 ms / After: 80 ms) View the test results Speed up your site tremendously, improve core web vitals and the overall user experience for your visitors without having to change your WordPress host, theme, plugins or your content production workflow. What users have to say: Read testimonials from W3TC users. Who do I thank for all of this? It’s quite difficult to recall all of the innovators that have shared their thoughts, code and experiences in the blogosphere over the years, but here are some names to get you started: Steve Souders Steve Clay Ryan Grove Nicholas Zakas Ryan Dean Andrei Zmievski George Schlossnagle Daniel Cowgill Rasmus Lerdorf Gopal Vijayaraghavan Bart Vanbraban mOo [villu164] (https://www.wordfence.com/threat-intel/vulnerabilities/researchers/villu164) Please reach out to all of these people and support their projects if you’re so inclined.