FormCMS is designed for speed and scale, rivaling specialized GraphQL engines while providing full CMS functionality.

Traditional CMS stores custom fields as key-value pairs:

| record_id | field_name | field_value |
|-----------|------------|-------------|
| 1         | title      | "Hello"     |
| 1         | price      | "29.99"     |

This is flexible but slow – you can't build indexes on arbitrary key-value data.

FormCMS creates actual database columns for each field:

| id | title   | price |
|----|---------|-------|
| 1  | "Hello" | 29.99 |

This allows you to build indexes and compound indexes on any field, enabling:

• Fast lookups by any column
• Efficient filtering and sorting
• Complex JOINs across related tables

FormCMS uses a multi-layer caching strategy to minimize database hits (see diagram below):

Most requests never reach the database.

High-volume user activities (likes, views, shares) are buffered in memory and batch-flushed every minute—achieving 19ms P95 at 4,200 QPS.

FormCMS uses different strategies for different types of data:

Content data (articles, products, courses) changes infrequently. Scale with caching and read replicas:

flowchart LR
    A[User Request] --> B[CDN Edge]
    B --> C[App Cache]
    C --> D[Read Replicas]
    D --> E[(Primary DB)]
    E -->|Sync| D

Activity data (likes, views, bookmarks) is high-volume. Scale by sharding based on user ID:

flowchart LR
    A[User Request] --> B{"hash(userId) % N"}
    B --> C[(Shard 0)]
    B --> D[(Shard 1)]
    B --> E[(Shard 2)]
    B --> F[(Shard N)]

Each shard handles a portion of users. Add more shards as you grow.

FormCMS architecture supports:

• News Portals: Millions of articles with CDN caching
• Online Courses: Complex hierarchies with efficient queries
• Video Platforms: HLS video + billions of view tracking
• Social Platforms: User-generated content with engagement features