Tag: queries
-
Syntax Highlighting SQL in Terminal
in Dev StuffDo you ever find yourself doing some debugging with error_log() or its friends? Does that debugging ever involve SQL queries? Are you tired of staring at grey queries all the time? I have just the product for you! Introducing Syntax Highlighting SQL in Terminal! Brought to you by our friends at Large Language Models, Incorporated,…
-
Gathering database performance with WP-CLI
in WordPressDiscover how we employed WP-CLI to streamline the assessment of database server performance in WordPress, facilitating a more efficient profiling of SQL queries before and after crucial server upgrades.
-
Quick Tip: Get Size of Revisions in WordPress
in WordPressMonitoring and managing data bloat in a WordPress site can be crucial. The introduction of the block editor has led to a surge in post revisions, which can clog up the database. Conducting a revision data audit using SQL queries can reveal the extent of unnecessary data accumulation, highlighting the importance of setting limits to…
-
Getting WordPress Database Size via WP-CLI
in WordPressA WordPress WP-CLI command `db-size` allows fetching database tables, their data, and index size in various formats. The command offers sorting options like total, table, data size, and index size. Use `–format` to adjust the output format (`table`, `csv`, `json`, `count`, `yaml`), and `–raw` for full byte size.
-
Query Caching (and a little extra)
in WordPressWordPress does not cache queries by default, but using the Advanced Post Cache plugin can improve performance. By caching `WP_Query` calls with a persistent object cache, performance can be enhanced even further with additional caching techniques for different queries and responses.