Maintenance in progress: we are indexing a large batch of new skills. Some pages may load slowly or briefly show no results. Nothing is lost, and everything is back to normal within the hour.
Profile My skills Saved Collections Edit profile Submit a skill

Optimizing Database Indexes

Guidelines for creating efficient database indexes in Appwrite. Use to ensure search and filter operations stay fast.

majiayu000 5bccb22 2 files · 1.7 KB Updated 567 repo stars
Coding & Dev Tools

File contents

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).

majiayu000/claude-skill-registry-data/tree/main/data/optimizing-database-indexes commit 5bccb22e6d

Browse category

Frequently asked questions

npx skillmds add majiayu000/optimizing-database-indexes