Database design

[codecandy2015]

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?

---