Database optimization in Wordpress - Performance & Optimization

Performance: Database optimization

HIGH IMPACT

This affects how quickly the website loads data from the database, impacting page load speed and user interaction responsiveness.

Fetching posts for a blog page

Wordpress

<?php $posts = $wpdb->get_results("SELECT ID, post_title FROM wp_posts WHERE post_status = 'publish' ORDER BY post_date DESC LIMIT 10"); foreach ($posts as $post) { echo $post->post_title; } ?>

Selects only needed columns and limits results to recent published posts, reducing data size and query time.

📈 Performance GainReduces server response time significantly; faster LCP.

Fetching posts for a blog page

Wordpress

<?php $posts = $wpdb->get_results("SELECT * FROM wp_posts"); foreach ($posts as $post) { echo $post->post_title; } ?>

This query fetches all columns and all posts without filtering, causing large data transfer and slow response.

📉 Performance CostBlocks rendering until full query completes; large data causes slow server response.

Performance Comparison

Pattern	DOM Operations	Reflows	Paint Cost	Verdict
Fetching all posts without filter	N/A (server-side)	N/A	N/A	[X] Bad
Fetching limited filtered posts	N/A (server-side)	N/A	N/A	[OK] Good

Rendering Pipeline

Database queries run on the server before HTML is sent to the browser. Slow queries delay HTML delivery, delaying browser rendering.

→Server Processing

→Network Transfer

→Browser Rendering

⚠️ BottleneckServer Processing (slow database queries)

Core Web Vital Affected

LCP

This affects how quickly the website loads data from the database, impacting page load speed and user interaction responsiveness.

Optimization Tips

1Always select only the columns you need in queries.

2Use WHERE clauses to filter data and LIMIT to reduce result size.

3Implement caching to avoid repeated expensive queries.

Performance Quiz - 3 Questions

How does limiting database query results affect page load?

A It reduces server response time and speeds up page load

B It increases server load and slows down page load

C It has no effect on page load

D It causes more reflows in the browser

DevTools: Network

How to check: Open DevTools, go to Network tab, reload page, and check the time for the main document request.

What to look for: Look for long server response times indicating slow database queries delaying page load.