Database design for heavy timed data logging
- by user293995
Hi,
I have an application where I receive each data 40.000 rows. I have 5 million rows to handle (500 Mb MySQL 5.0 database).
Actually, thoses rows are stored in the same table = slow to update, hard to backup, ...
Which king of scheme is used in such application to allow long term accessibility to the datas without problems with too big tables,…