From a million-dollar list, one-time find out tens of thousands or tens of data, speed is slow, have any good solution?

Other information:
Table itself data volume is not large, if the query a few records, is quickly;
The SQL statement should be no problem, so temporary don't have to consider the optimization for the index;
Are using the innodb storage engine (for MyISAM?) .

CodePudding user response:

A query out tens of thousands of article, this article tens of thousands of take up disk space is how much, the network transmission need how long,

CodePudding user response:

Does not SQL statements there is no problem don't need to optimization, optimization of a good variety of, have database optimization, optimization, different optimization together may have other effects

CodePudding user response:

reference 1st floor AHUA1001 response:

a query out tens of thousands of article, this article tens of thousands of take up disk space is how much, the network transmission need how long,

sometimes dozens of k, a page (16 k) than the innodb storage volume is much bigger, now is in the local, not the consumption of network transmission,

CodePudding user response:

refer to the second floor you are little KS reply:

does not SQL statements there is no problem don't need to optimization, optimization of a good variety of, have database optimization, optimization, different optimization together may have other effects

you can think SQL has been optimized, no need to worry this problem didn't do (in addition to the paging)

CodePudding user response:

reference 4 floor yvanmiaoyi response:

Quote: refer to the second floor you are little KS reply:

Does not SQL statements there is no problem don't need to optimization, optimization of a good variety of, have database optimization, optimization, different optimization together may have other effects

you can think SQL has been optimized, no need to worry this problem didn't do (in addition to the paging)

Suggestions were split, or SQL interception, use the cache, and multiple databases combined together to complete a query