ClickHouse / ClickHouse/CryptoHouse

Task - improve schema for solana

Open
#4 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
TypeScript
Stars
68
Forks
9
PR merge metrics
No merged PRs in 30d

Description

- [ ] Schema has nullable types
- [ ] Excessive number of bits on ints - wasting memory.
- [ ] Store block hashes as fixed string binary - then alias columns for presentation. @alexey-milovidov proposed for performance.
- [ ] Reassess the primary key

Above probably needs insert to be paused. Also we will need to check queries aren't impacted.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.