current position:Home>Java MySQL single table ten million level data summation

Java MySQL single table ten million level data summation

2022-02-03 02:05:18 CSDN Q & A

Is to find out all the data directly and then put it in the code for Loop summation is fast Still sql in sum fast




Refer to the answer 1:

The program is fast ? I just tried. In less than a second   Embarrassed rz




Refer to the answer 2:



Refer to the answer 3:

In general , Of course is in sql Li Kuai .
But in some extreme cases , Like databases cpu Special garbage , But disk express , Internet Express , Then the application side memory is very large and the frequency is very high , Plus the application side cpu ultrafast , It is possible to apply it faster , Because the database card owner ...




Refer to the answer 4:

copyright notice
author[CSDN Q & A],Please bring the original link to reprint, thank you.
https://en.primo.wiki/2022/02/202202030205163083.html

Random recommended