SurrealQL Performance

Techniques for making SurrealDB queries fast: structuring record IDs and keys for data locality, choosing and verifying the right indexes, and precomputing values with computed fields and views instead of recomputing them on every read.

Target the latest stable SurrealDB release. Confirm version-sensitive syntax (record ranges, COMPUTED fields, FULLTEXT index options) against https://surrealdb.com/docs, and validate examples with surreal validate. See the surrealql skill for version detection.

When to use this skill

• A query is slow or scans more records than expected
• Designing record IDs to support efficient lookups and range scans
• Choosing between standard, UNIQUE, full-text SEARCH, or vector indexes
• Confirming whether an index is actually used (EXPLAIN)
• Deciding whether to store a derived value vs. compute it on read