8 articles
Every article tagged Database, newest first. Search all articles
Development8 min read
WordPress custom tables vs custom post types for plugin data
For a WordPress custom table vs custom post type decision, use a custom post type when your data behaves like editable WordPress content. Use a custom table when the data is high-volume, query-heavy, or needs typed columns and indexes that match your plugin's access patterns.
Performance7 min read
WooCommerce Action Scheduler: clear a backlog and keep it healthy
A WooCommerce Action Scheduler backlog means scheduled background work is arriving faster than it is being processed, or processing has stopped. Start by grouping pending and failed actions by hook, fix the hook or cron problem, then drain the queue with WP-CLI instead of deleting unknown jobs.
Performance7 min read
WooCommerce HPOS: migrate to High-Performance Order Storage safely
WooCommerce HPOS moves core order data out of WordPress post storage into dedicated WooCommerce tables. Migrate safely by checking extension compatibility, synchronizing both data stores, verifying them, switching HPOS to authoritative, then testing every order workflow before you disable synchronization.
Performance6 min read
Why a cache purge can overload WordPress and how to stop it
A WordPress cache stampede happens when many requests lose the same cached data at once and all try to rebuild it. The fix is to limit rebuilds with a shared lock, keep stale data available during refresh, and spread expiries so misses do not arrive as one burst.
Development5 min read
WordPress plugin database migrations with dbDelta, done safely
WordPress plugin database migrations should compare a stored schema version with the version your plugin expects, then run only the missing steps. Use dbDelta() for table creation and supported schema changes, and use explicit, guarded migrations for destructive or unsupported changes.
Performance8 min read
How to find and fix slow WordPress database queries
WordPress slow database queries are usually found by measuring the actual SQL, its execution time, and how often it runs before changing indexes or code.
Performance8 min read
How to fix a slow WordPress admin dashboard without guesswork
To fix slow WordPress admin screens safely, time one repeatable request, profile the work inside that request, then change one cause at a time. Query Monitor, browser Network data, WP-CLI, and the database can show whether the delay comes from SQL, AJAX, scheduled jobs, remote HTTP calls, or memory pressure.
Performance8 min read
WordPress Redis object cache: setup and measurement
A WordPress Redis object cache keeps WordPress object-cache data available across requests, so PHP can reuse cached query results and other objects instead of rebuilding them each time.