WooCommerce Performance Optimization

Performance optimization is crucial for a WooCommerce store. Here are my proven techniques to maximize performance while maintaining an excellent user experience.

Server Optimizations

PHP Configuration

memory_limit = 256M
max_execution_time = 300
post_max_size = 64M
upload_max_filesize = 32M
max_input_vars = 3000

MySQL Configuration

innodb_buffer_pool_size = 1G
innodb_file_per_table = 1
innodb_flush_method = O_DIRECT
innodb_log_buffer_size = 16M
query_cache_size = 0

Advanced Caching

Redis Object Cache

define('WP_CACHE', true);
define('WP_REDIS_HOST', 'localhost');
define('WP_REDIS_PORT', 6379);

// Object cache configuration
wp_cache_add_global_groups([
    'woocommerce',
    'products',
    'orders'
]);

Full-Page Cache

class WC_Advanced_Cache {
    private $cache_path;
    
    public function __construct() {
        $this->cache_path = WP_CONTENT_DIR . '/cache/wc-pages/';
        add_action('template_redirect', [$this, 'cache_page']);
    }
    
    public function cache_page() {
        if ($this->is_cacheable()) {
            $cache_key = $this->generate_cache_key();
            $content = $this->get_cached_content($cache_key);
            
            if (!$content) {
                ob_start([$this, 'save_cache']);
            } else {
                echo $content;
                exit;
            }
        }
    }
}

Database Optimization

Automatic Cleanup

class WC_DB_Optimizer {
    public function cleanup_old_data() {
        global $wpdb;
        
        // Delete old sessions
        $wpdb->query("
            DELETE FROM {$wpdb->prefix}woocommerce_sessions 
            WHERE session_expiry < UNIX_TIMESTAMP(NOW() - INTERVAL 30 DAY)
        ");
        
        // Clean orphaned metadata
        $wpdb->query("
            DELETE pm FROM {$wpdb->postmeta} pm
            LEFT JOIN {$wpdb->posts} p ON p.ID = pm.post_id
            WHERE p.ID IS NULL
        ");
    }
}

Query Optimization

class WC_Query_Optimizer {
    public function optimize_product_queries($query) {
        if (!is_admin() && $query->is_main_query() && is_shop()) {
            $query->set('no_found_rows', true);
            $query->set('posts_per_page', 24);
            $query->set('update_post_meta_cache', false);
            $query->set('update_post_term_cache', false);
        }
    }
}

Asset Optimization

Minification and Concatenation

add_action('wp_enqueue_scripts', function() {
    wp_enqueue_style(
        'wc-optimized',
        get_template_directory_uri() . '/assets/css/wc-optimized.min.css',
        [],
        THEME_VERSION
    );
    
    wp_enqueue_script(
        'wc-optimized',
        get_template_directory_uri() . '/assets/js/wc-optimized.min.js',
        ['jquery'],
        THEME_VERSION,
        true
    );
}, 20);

Lazy Loading Images

class WC_Image_Optimizer {
    public function optimize_product_images($html) {
        if (strpos($html, 'wp-post-image') !== false) {
            $html = preg_replace(
                '/src=["\'](.*?)["\']/',
                'src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" data-src="$1"',
                $html
            );
            $html = str_replace('class="', 'class="lazyload ', $html);
        }
        return $html;
    }
}

Checkout Optimization

AJAX Validation

class WC_Checkout_Optimizer {
    public function validate_fields() {
        add_action('wp_ajax_wc_validate_checkout', [$this, 'ajax_validate']);
        add_action('wp_ajax_nopriv_wc_validate_checkout', [$this, 'ajax_validate']);
    }
    
    public function ajax_validate() {
        $fields = $_POST['checkout_fields'] ?? [];
        $errors = [];
        
        foreach ($fields as $key => $value) {
            if (!$this->validate_field($key, $value)) {
                $errors[$key] = $this->get_error_message($key);
            }
        }
        
        wp_send_json([
            'valid' => empty($errors),
            'errors' => $errors
        ]);
    }
}

Monitoring and Analytics

Performance Tracking

class WC_Performance_Monitor {
    private $metrics = [];
    
    public function track_metric($name, $value) {
        $this->metrics[$name] = [
            'value' => $value,
            'timestamp' => microtime(true)
        ];
    }
    
    public function get_report() {
        return [
            'page_load' => $this->get_page_load_time(),
            'db_queries' => $this->get_db_query_count(),
            'memory_usage' => memory_get_peak_usage(true),
            'cache_hits' => wp_cache_get_stats()
        ];
    }
}

Results Achieved

1. Performance

   • Load time < 2s
   • PageSpeed score > 90
   • TTFB < 200ms

2. Database

   • 40% query reduction
   • Index optimization
   • Automatic cleanup

3. User Experience

   • Smooth loading
   • Instant navigation
   • Optimized checkout

Conclusion

WooCommerce optimization is an ongoing process that requires a comprehensive approach. These techniques help achieve a high-performing store with optimal user experience.