Bits of .NET

🚀 Database Queries: 100 → 5

Every page load = 100 database queries. Redis caches them in memory. Page generation: 800ms → 80ms.

🔄 Without Object Cache

Page Load Request:
1. Query database for site options (10 queries)
2. Query for user data (5 queries)
3. Query for post meta (20 queries)
4. Query for taxonomies (15 queries)
5. Query for widgets (10 queries)
... 100+ total queries

Every. Single. Page. Load.
Result: Slow, DB overload

✅ With Redis Object Cache

First Page Load:
- Queries database (100 queries)
- Stores results in Redis (in RAM)

Next 999 Page Loads:
- Gets cached data from Redis (5 queries)
- Database barely used

Result: 10x faster, 95% less DB load

Step 1: Install Redis

# Ubuntu/Debian
sudo apt-get install redis-server
sudo systemctl start redis
sudo systemctl enable redis

# Verify
redis-cli ping
# Should return: PONG

Step 2: Install WordPress Plugin

Install “Redis Object Cache” plugin by Till Krüss

Plugins → Add New → Search “Redis Object Cache” → Install & Activate

Step 3: Configure wp-config.php

// Add to wp-config.php (before 'That's all, stop editing!')

define('WP_REDIS_HOST', '127.0.0.1');
define('WP_REDIS_PORT', 6379);
define('WP_REDIS_TIMEOUT', 1);
define('WP_REDIS_READ_TIMEOUT', 1);
define('WP_REDIS_DATABASE', 0);

// Optional: Password protection
// define('WP_REDIS_PASSWORD', 'your-redis-password');

Step 4: Enable Object Cache

Settings → Redis → Click “Enable Object Cache”

Status should show “Connected”

⚠️ Important Notes

• Flush cache: After theme/plugin updates, flush Redis cache
• Memory limit: Redis stores in RAM. Monitor memory usage
• Persistence: Configure Redis persistence for production
• Security: Set Redis password, bind to localhost only