ZiziCache analyzes your database and provides intelligent recommendations for creating database indexes, which can significantly improve query performance.

Automatic Index Analysis

The plugin analyzes the following aspects of the database:

• Existing indexes: An overview of current indexes
• Table statistics: Number of records, data size, and index size
• Recommended indexes: Proposals for new indexes for optimization
• Recommendation priority: High, medium, low based on impact

Types of Recommendations by Tables

The plugin provides specific recommendations for different types of WordPress tables:

• Posts table: Indexes for post_status, post_type, post_date
• Comments table: Optimization for comment_approved, post_ID
• Options table: Indexes for autoload and option_name
• Meta tables: Composite indexes for meta_key and meta_value

Slow Query Analysis

If SAVEQUERIES is active, the plugin analyzes slow queries and identifies optimization opportunities:

• Detection of queries taking longer than 1 second
• Analysis of frequent patterns in queries
• Recommendations for optimizing problematic queries

Security Approach

The plugin only recommends indexes but never creates them automatically to prevent unwanted changes to the database. All recommendations must be implemented manually.

Optimization Reports

The system generates detailed reports containing:

• Total number of recommendations
• Breakdown by priority (high/medium/low)
• Analysis of available performance issues
• Timestamp of the analysis