How to distribute call logs across the database?

Question

CMS

Good afternoon. I wrote a call history parser from our PBX. The logger works as it should, but the question arose how to distribute the collected logs across the database? Collect everything in a heap, creating a new table once a month? Or is it better to immediately distribute logs to tables created for each department? And what cms is better to use to view these statistics from the browser?

Answer 1

To collect everything in one table with indexes put down correctly (according to your requirements).
Make the department column naturally, not a new plate.
CMS is not needed here at all, in fact there will be 2 pages, where you fill in the departments that you have, etc., knit them by number prefix, or by number, this is your logic in short.
I would advise you to throw another Laravel mini admin panel and a table with filters in the evening.

Answer 2

Two questions:
- first decide why you need this data, how and why to display it. Only then think about storage. Because it depends on the tasks what exactly you need to store.
- how many million calls do you have per hour to think about recording distribution?
Partitioning by month, however, will probably be useful. Deleting entire partitions is simply easier. Only it is to partition using regular DBMS tools, and not to invent some strange rake.