I have a solar monitor device that emits 10 parameters per minute, in Json format. What is the right way to store the data in DB:
- shall all minute entry be a separate document,
- or to keep all data from one device in one document,
- or to have multiple time-limited (daily, monthly) documents for one device?
- shall have separate collection for each device? What is a reasonable number of collections and documents to deal with?
Single vs multiple documents per data point is up to you depending on how you'll be using the data.
I typically create a collection per data type and void having multiple collections with the same schema
A collection should be able to handle billions of documents. Under the hood, a collection is a mariadb table so refer to the limitations there: https://stackoverflow.com/questions/56474252/max-number-of-records-can-mariadb-support
Recommended threads
- Issue related to index
Why it is showing this error?
- Project paused despite active use — rest...
Hey team! My Appwrite Cloud project (685579e5000d78e67009) has been marked as paused due to inactivity, but it's actively used in production. I clicked the Rest...
- Creation failedUnknown sort order:asc. M...
Hi there, I'm getting this error on self hosted when trying to create an Index. Any ideas?