Scalability & Performance Considerations

  • Database Indexing: Strategic use of PostgreSQL B-tree indexes on foreign keys (e.g., market_id, user_address) and BRIN indexes on time-series tables for the timestamp column.

  • Caching Strategy: Multi-layer caching using Redis:

    • API-level caching for frequent, expensive queries (e.g., top markets, leaderboard).

    • Database query result caching.

  • Horizontal Scaling: The Event Processor and API layers are stateless and can be scaled horizontally. The Message Queue allows for multiple consumer groups to parallelize event processing.

PreviousCore Technical MechanismsNextFuture Technical Roadmap

Last updated