Minimizing the use of database metadata methods

Although almost no JDBC application can be written without database metadata methods, compared to other JDBC methods, database metadata methods are slow. When we use a metadata method, a SELECT statement makes two round-trips to the database: one for metadata, and the second for the data. This is very performance expensive. We can improve the performance by minimizing the use of metadata methods.

An application should cache all metadata, as they will not change, so multiple executions are not needed.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset