Problems with library design?

mephistox

I just came into contact with the database. I now make a monitoring system. There are more than 200 monitoring points. Each monitoring point reports data to the center once an hour. How should I design the database to make the query more efficient. I think it is feasible to build a watch every month? How should I query multiple tables when querying? Thank you, boss!

fanfan1980

How to check multiple tables when querying?

Associate multiple tables to check

mephistox

Can you elaborate? How to check the same structure?

waxiaoning

No need to separate, there will be no multi-table query problem

fanfan1980

Is it feasible to build a watch every month?

-
Not necessary

mephistox

If it takes a long time to build a table, will there be too much data, and the query will be too slow?

terran1208

1. Set up pk
2. Create an index
3. Improve hardware configuration
4. Optimize SQL

mephistox

If there are 10 million records in a table, will the query speed be full?

unkmass

The amount of data is definitely slow.

waxiaoning

Multi-table joint query is definitely slower than query in Dan table
Ten million items also depend on the amount of data (size), if occasionally joint queries, it is best to do separately