A million + data tables, has set up a field index, through this field queries will need about 1 s, combined with the background of records returned as average, extremum process take about 1 s +, total business layer a load data need to use more than 10 fields, so the request data totally takes about 10 s +, but party a think slowly slowly, to optimize, director (not understand), said other projects built by triggers and stored procedures to achieve the effect of instant return, may I ask you BBS under bosses, whether can really?

CodePudding user response:

Why don't query the 10 fields, 10 times to request?

CodePudding user response:

Associated with the query, one million data of article 10 s is very slow

CodePudding user response:

reference 1st floor trainee response:

why don't query the 10 fields, 10 times to request?

The or or not makes the index in the failure?

CodePudding user response:

Millions of data 1 seconds, if not with little overlord server, is absolutely index didn't work

CodePudding user response:

reference wave yuppie reply: 3/f

Quote: refer to 1st floor trainee response:

Why don't query the 10 fields, 10 times to request?

The or or not makes the index in the failure?

10 don't explain it is to be seen