Skip to content

Strategies for higher write throughput. #31

@gnat

Description

@gnat

Sharing a few strategies here. Can be converted to a discussion at your discretion.

  • Enabling WAL2: Any plans for WAL2 / BEGIN CONCURRENT? #30
  • Write batching / bulk INSERT
    • Used by rqlite (sacrifices durability for throughput).
    • Not all writes may be suitable for batching.
  • Multiple databases for writes, then ATTACH for reads.
# main.yaml
scheduledTasks:
  - atStartup: true
    statements:
      - ATTACH 'sessions.db' as sessions

You can then:

SELECT count(*) FROM sessions.users;

Perform JOIN, etc.

Multiple databases enable you to multiply your throughput.

Share your strategies!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions