Database Indexing Strategy

When to use this skill

• When queries are becoming slow.
• Before launching categories, search, or price sorting filters.

Index Types

• Key: For simple equality checks (e.g., userId).
• Fulltext: For searching titles and descriptions.
• Unique: For fields like email or slug that must not repeat.

Rules

• Query Alignment: Every field used in a Query.equal or Query.orderAsc should be indexed.
• Index Order: For compound queries, the order of attributes in the index matters (e.g., Price + Status).

Instructions

• Monitor: Watch the Appwrite "Usage" tab to identify slow queries.
• Limit: Don't index every single field; it slows down writes (Creation/Updates).