skip to main content
Designing JDBC applications for performance optimization : Using database metadata methods
  

Try DataDirect Drivers Now

Using database metadata methods

Because database metadata methods that generate ResultSet objects are slow compared to other JDBC methods, their frequent use can impair system performance. The guidelines in this section will help you optimize system performance when selecting and using database metadata.
* Minimizing the use of database metadata methods
* Avoiding search patterns
* Using a dummy query to determine table characteristics