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, easy backup, fast read / write ?
Is postgresql better than mysql for such purpose ?
Thanks in advance
BEst regards