Which is best way of creating a database for each or one table in a database in MySQL?

  Kiến thức lập trình

We are working on IoT device, each device will stores about 20 mb of data each month and we have 20K and more IoT devices in the filed. we need storage for 7 years. So which is best way of creating database for each device or one database with one table or one database with multiple tables ?

  • mysql

New contributor

Thirupathi Katukam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

LEAVE A COMMENT