Database design

I am working with Scylla for the first time. I have a very generic question. my usage is aboute storing and retriving sensor data. The question i have is:-

Would it make sense from a performance prespective to have one table per sensor - this would have a consequence of having 1000s of tables. OR

would it make sense to have one BIG table with million rows of data - this one table would be heavily read and written to.

any suggestions or thoughts would be highly appreciate.

Please answer these questions before submitting your issue. Thanks!

What version of Scalla are you using?
5.4.0

What version of Gocql are you using?
1.2.0

What version of Go are you using?
1.21.5

What did you do?

What did you expect to see?

What did you see instead?

---

This is a general database-design question about storing and retrieving sensor data, not a defined change to the driver. No source file, test, or entry point is named, and the issue does not specify an actionable completion condition.

Written by the indexing model from the issue text.