SQL statement impact on ResultSet efficiency in Java

zhaozj2021-02-16  64

During the test, it was found that a method was performed long, so it started to efficiently test this code. The code is very simple. It is taken from the two tables through a SELECT statement, and the amount of data is small, and then the result is traversed by the resultT.next () method and writes the data into a vector.

The test results found that the index of the two tables has been established, and the speed of SQL is not executed is not slow, and later discovered that it is relatively long. This time consumption is longer lies in SQL in the SQL, while the ORDER BY will only occur after multiple tables. If it is only selected from a table, it will not cause efficiency. The impact.

Practice has no data support, and there is time to write a test code to get more dependent data.

Database SQL Serve2000.

Copyright: IDILENT website reproduced please indicate the author's other reprint, please contact the author (iDilent@yahoo.com.cn).

转载请注明原文地址:https://www.9cbs.com/read-16217.html

New Post(0)