Database optimization in Wordpress - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding WordPress Database Indexing

Which of the following best describes the purpose of adding indexes to WordPress database tables?

A Indexes automatically delete duplicate rows to keep the database clean.

B Indexes compress the database tables to save disk space and reduce backup size.

C Indexes speed up data retrieval by allowing the database to find rows faster without scanning the entire table.

D Indexes encrypt the database content to improve security.

💡 Hint

Think about how a phone book helps you find a name quickly.

Indexes in databases work like a phone book index. They help the database find data quickly without looking at every row.

❓ component_behavior

intermediate

Effect of Excessive Post Meta on Performance

In WordPress, what is the likely performance impact of having thousands of post meta entries for a single post without proper indexing?

A Queries retrieving post meta will slow down significantly because the database must scan many rows.

B The post will load faster because more meta means more cached data.

C There will be no impact because WordPress caches all post meta automatically.

D The database will automatically remove extra post meta to keep performance stable.

💡 Hint

Think about searching through a large messy drawer versus an organized one.

Without indexes, the database must scan many rows to find meta data, which slows queries.

📝 Syntax

advanced

Correct SQL to Add an Index in WordPress Database

Which SQL command correctly adds an index on the 'post_id' column of the 'wp_postmeta' table to improve query speed?

A CREATE INDEX idx_post_id ON wp_postmeta(post_id);

B ADD INDEX idx_post_id TO wp_postmeta(post_id);

C INDEX CREATE idx_post_id ON wp_postmeta(post_id);

D ALTER TABLE wp_postmeta ADD INDEX (post_id);

💡 Hint

The standard SQL command to create an index starts with 'CREATE INDEX'.

The correct syntax to add an index is 'CREATE INDEX index_name ON table(column);'. Option A follows this.

🔧 Debug

advanced

Identifying Cause of Slow WordPress Queries

A WordPress site is slow when loading posts with many custom fields. The developer runs this query:
SELECT * FROM wp_postmeta WHERE meta_key = 'color' AND post_id = 123;
Which issue most likely causes the slow query?

A The query syntax is incorrect and causes a syntax error.

B There is no index on the 'meta_key' and 'post_id' columns, causing a full table scan.

C The 'wp_postmeta' table is missing the 'color' column.

D The 'post_id' value 123 does not exist, causing the query to hang.

💡 Hint

Think about how the database finds rows matching multiple conditions.

Without indexes on the columns used in WHERE, the database scans the entire table, slowing queries.

❓ state_output

expert

Result of Running wp_cache_flush() in WordPress

What is the effect on the WordPress site immediately after calling wp_cache_flush() in a plugin?

A The database tables are optimized automatically to improve performance.

B Only the object cache for the current user session is cleared.

C The site disables caching permanently until the plugin is deactivated.

D All cached data is cleared, causing slower page loads until cache rebuilds.

💡 Hint

Think about emptying a fridge: everything is gone and needs to be restocked.

wp_cache_flush() clears all cached data, so the site must rebuild cache, causing temporary slower loads.