Requirements:
100 form a list (one day), the field has id, MAC, date, MAC field according to the statistics,
In the 100 list record the total number of article, namely, similar to the SQL group by MAC, count, if use a relational database query will slowly,
Whether can use lucene solution, whether there is any better solution?


Is 100 tables, a day, every day a, table records is equipment acquisition data, use of these data for data analysis,

CodePudding user response:

A table every day, that is to say the data structure is the same, according to the time into different table, right,
If so, suggest you put the data in a table, increase partition by date, will reduce a lot of trouble,

CodePudding user response:

Do telecom projects are generally built before the partition table, normal tens of millions of the amount of data, so a few group by field, the query efficiency is not very slow

CodePudding user response:

Write a stored procedure, regular operation, every day will be the day of good statistics on a TAB, the TAB will produce a record every day, 100 days is just 100 records, much faster than real time use lucene query,