![]() ![]() Java trouble to write, execute test scripts SPL: ![]() JDBC interface provided by Oracle, SQL statements perform data reading. Database table data and text files are stored on a hard drive with an SSD.Īll tests were completed on the server machine, it does not consume network transmission time. ![]() Test EnvironmentĬomplete testing on an Intel server, two Intel2670 CPU, clocked at 2.6G, a total of 16 cores, memory 64G. This file import tool to import data to Oracle and MySQL data tables using data provided by the database. It generates a raw text file named customer.tbl, the file size is 4.9G. TPCH generated using data, wherein the selection of the customer table to do the test, data is recorded as 30 million rows, eight fields. Here (in order to use after all to this point in the application) test only JDBC read data, and produce records to Java objects, without any calculation. The reason why the test JDBC, because most applications are written in JAVA, it can only use JDBC to access data. We now come to the actual test, how the performance of commonly used Oracle and MySQL JDBC read. Often hear people say, IO poor performance of the database, but said go, and not perceptions. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |