Home > Back-end >  The 2021-01-13: a lot of columns of data, any column combination query, mysql can do it, but hundred
The 2021-01-13: a lot of columns of data, any column combination query, mysql can do it, but hundred

Time:01-14

The 2021-01-13: a lot of columns of data, any column combination query, mysql can do it, but hundreds of millions of the amount of data that do not arrive, check of time is very slow, we need an engine to support it, you have to understand this engine?

CodePudding user response:

You this is ad-hoc query, that is, optional combination,
Advice to see column MPP databases, such as GBase 8 a, GP, etc.,

CodePudding user response:

So large amount of data that why not depots table, put a table is not right

CodePudding user response:

Large amount of data to focus Search can be considered Elastic Search (ES)
  • Related