Many interviewers will ask how many quantity of the data can improve performance of this one is the standard answer interviewers want to hear what is want to have a great god to explain

CodePudding user response:

There is, also have no,

Like master taught his little student "speed is slow, response is slow, internal force is not enough" -- -- -- -- -- -- -- -- -- -- this is the absolute truth, than Bruce lee, you can also so lesson Bruce lee

This thing say, is the same as the above have a standard answer, that is open source + throttling, like into water conservancy project, the floods do
Shunt (distributed), can be built reservoirs can (cache), water can take the single throughput) (increased, and the flood discharge can (blow up the dam, the water into the empty area, the ans also spare no, directly rejected), multistage scheduling can (multistage cache)
It said no, because even if you know that open source throttling 4 words also can't help you, let us go to see the specific situation, what is that of fixed template

CodePudding user response:

There is no standard answer, that is, the two aspects to do optimization, and database code, the code can establish caching mechanism, using asynchronous operations and so on, the database can build indexes to the table, complex queries using stored procedures, such as anyway which is able to improve performance of can you say

CodePudding user response:

The question more broadly, according to the actual situation,
But there is a will work add hardware, enhance memory, promote solid, upgrade the CPU, a few more machine...

Depots, table, historical data, load balance and multithreading, cache...

CodePudding user response:

CodePudding user response:

General issues, the interviewer may just want to know if you have certain experience of database optimization, in general you know index, and truthful, and understand the problem of some indexes, this aspect can be gone

, of course, if your post is advanced or architect, that will be involved in the data quantity is how much, if you need to be table depots, separation, speaking, reading and writing etc.

Cache aspects with large amount of data is not very match

CodePudding user response:

Depends on the background of enterprise/position, it is really a huge amounts of data/mass users such scene, if not, it is bullshit,
Really have huge amounts of data/mass users such scenes will not ask how to improve performance this broad questions, but should ask some specific, allow you to write a map - reduce algorithm, let you tell me about a star, how to return a responsibility, how to do collaborative filtering, secondary principle of such a framework, etc.,
Open my mouth to ask how many quantity of the data performance, let a person feel very low is there,

CodePudding user response:

Best is distributed, but any distributed are required to the network, and atomic take into account that