Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Improve storage efficiency #62

Open
jeremyestein opened this issue Oct 3, 2024 · 0 comments
Open

Improve storage efficiency #62

jeremyestein opened this issue Oct 3, 2024 · 0 comments

Comments

@jeremyestein
Copy link
Collaborator

jeremyestein commented Oct 3, 2024

Currently using DOUBLE PRECISION ARRAY. Could use NUMERIC ARRAY instead. Most streams have values with not many digits in them, so NUMERIC ARRAY with low parameters could be quite efficient. If some streams have more digits in, consider using separate "big" and "small" waveform tables to maximise storage efficiency (at some cost to user friendliness - could be improved with an SQL view that is the union of both tables?)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant