Recent work on a project, kanban, real-time schedule needs to be regularly pull data from ERP database (a dozens or hundreds of pen), inserted into a mysql table, such as frequency for 2 minutes at a time; And then use a kanban tools, from this table, fetching data for rendering on a regular basis ((such as 1 minutes);

My idea is:
Design two tables: 1) every insert, just insert the table A: produce A 32-bit random ID, and the corresponding lot of detailed data, then the 32-bit random ID update to another table B
Anderson, D, for example, A.c odetype, col1, col2, col3
1 type1 101 zhang SAN men
1 type2 102 li si female
2 type3 103 king beauty female
B,
B.I D, biggest odeType;
1 type1
2) tool at the time of the query, the latest id, only need to query this data type is then associated with table A, can find the latest data;

(3) the daily scheduling delete junk data such as 12 noon every day and night 12 o 'clock), remove data from table A and table B

CodePudding user response:

Which can help myself, so that the design of the model whether there will be a serious performance issues? Or is said at the time of kanban tool to query data, because the update latest ID, and cause the problem of unable to read? Or whether there is any better solution, thank you!

CodePudding user response:

Is there a warrior take time to look at