Access the database through ibaties and return the list to Javalist. the mysql console queries the Java code for 0.004 seconds for about 1 minute. In some cases, you can use the mysql management tool to query millions of data. in simple SQL statements, the actual data time is 4 minutes, and the query time returned by the system is 0.002 seconds. How to optimize this kind of problem. thank you for adding: do not consider hardware .! [Image description ((img.ask.csdn.netupload201510141444815852_51136.png) mysql Performance java
Access the database through ibaties and return the list to the Java list. the mysql console queries Java code execution for 0.004 seconds for about 1 minute. In some cases, you can use the mysql management tool to query millions of data. in simple SQL statements, the actual data time is 4 minutes, and the query time returned by the system is 0.002 seconds. How to optimize this problem? thank you.
Note: hardware is not considered.