Windows PC, please i5 CPU, the memory of 4 g, how about using mysql efficiency, such as a maximum 100000 records check and estimate how long time

CodePudding user response:

This kind of relationship with the PC configuration is not much, I think if you have a problem network oh. My side has a 2000 + W table, check the maximum, spent 18 seconds, around 10 W table, the maximum value should be a millisecond

CodePudding user response:

Indexed, 10 w maximum record check, tens of milliseconds; Millions or tens of millions of query efficiency has certain will be reduced

CodePudding user response:

The index, hundreds of millions of data will not slow, 10 w, index needless to say, will soon, don't walk the index, the slowest is the second level,

CodePudding user response:

100000 records to check ah, access can deal with it?
Check today just come across a three indexes, the 5 seconds faster, afterward went to see, only 9 million data