How should we design the statistical tables of various data in the crm system?

Source: Internet
Author: User
The company is building a crm system. There is a lot of data statistics that need to be recorded in the database. For example, record the number of customers per employee per day, the number of tracking records, whether the number of customers per day is up to standard, and whether the number of tracking records is up to standard. There are two solutions: 1. these statistics... the company is working on a crm system. There is a lot of data statistics that need to be recorded in the database.
For example, record the number of customers per employee per day, the number of tracking records, whether the number of customers per day is up to standard, and whether the number of tracking records is up to standard.
Currently, two solutions are proposed:
1. these statistics are recorded in a table.
2. Each statistical data item is recorded separately in a table.
I don't know. which method is better? Or are there other better and more complete implementation methods?
I would like to thank you for your comments.

Reply content:

The company is building a crm system. There is a lot of data statistics that need to be recorded in the database.
For example, record the number of customers per employee per day, the number of tracking records, whether the number of customers per day is up to standard, and whether the number of tracking records is up to standard.
Currently, two solutions are proposed:
1. these statistics are recorded in a table.
2. Each statistical data item is recorded separately in a table.
I don't know. which method is better? Or are there other better and more complete implementation methods?
I would like to thank you for your comments.

We recommend that you enable timed statistics in the background.

If the data volume in the later stage is large, it is recommended to put it in each table separately. because the data volume in the later stage is large, the table still needs to be split, so it is better to split it now. Do not forget to create related indexes.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.