|
Java Programming with Oracle JDBC: Performance
Performance is usually considered an issue at the end of a development cycle when it should really be considered from the start. Often, a task called "performance tuning" is done after the coding is complete, and the end user of a program complains about how long it takes the program to complete a particular task.
|
|
JDBC Performance Tips
In recent years, the AS/400 interface for native JDBC has become very popular. As more and more Java applications come to the platform, there is a growing need for more information on performance hints, and coding techniques. This article will provide some tips on getting the best performance from Java applications that use JDBC. The article will include code examples in Java.
|
|
Atomic File Transactions, Part 1
One of the many powerful features that transaction-processing systems provide is atomicity. An activity is atomic if it either happens in its entirety, or does not happen at all. Atomicity is crucial for writing correct software in many applications; for example, a bank's software may implement a transfer from account A to account B as a withdrawal from A followed by a deposit to B. If the first action happens, then the second had better happen as well.
|
|
What areas should I focus on for the best performance in a JDBC application?
Use a connection pool mechanism whenever possible.
Use prepared statements. These can be beneficial, for example with DB specific escaping, even when used only once. etc
|
|
Managing database connections with JDBC
This tutorial introduces the different concepts involved in establishing and managing a database connection from within a Java application using Java Database Connection (JDBC). It is targeted primarily at developers who want to understand what is going on "under the hood" when using a database from within a Java application.
|
|
Optimization with Connection
java.sql package in JDBC provides Connection interface that encapsulates database connection functionality.
|
|
Optimization with Statement
Statement interface represents SQL query and execution and they provide number of methods and constants to work with queries. They also provide some methods to fine tune performance. Programmer may overlook these fine tuning methods that result in poor performance.
|
|
Optimization with ResultSet
ResultSet interface represents data that contains the results of executing an SQL Query and it provides a number of methods and constants to work with that data. It also provides methods to fine tune retrieval of data to improve performance.
|
|
Optimization with SQL Query
This is one of the area where programmers generally make a mistake .
|
|
Creating Optimized JDBC Applications
While Java databases have become essential for Web applications, developing performance-oriented Java Database Connectivity (JDBC) applications can be challenging. But by following tried-and-true approaches, it is possible to develop and fine-tune JDBC applications to make them run faster, jump higher, and make fewer trips to the database.
|
|
Tuning JDBC: Measuring JDBC performance
Java Database Connectivity (JDBC) is used extensively by many Java applications. In this article, the first of a series on performance-tuning JDBC, I look at how to measure the performance of JDBC and how to identify which parts of your JDBC subsystem need optimizing.
|
|
JDBC Performance Test
JDBC Driver Performance tests.
|
|
Performance tuning your JDBC application
The concepts involved with Java, JDBC, and DBMS processing are new to many programmers. As Java becomes more widely used, database access and database applications will become increasingly easy to implement. This document provides some tips on how to obtain the best performance from JDBC applications.
|
|
Examining The Network Performance Of JDBC
Java has a performance problem that hardware and software engineers are working overtime to solve. The problem often manifests itself in the portion of Java programs that interface with databases.
|
|
Best practices to improve performance in JDBC
JDBC stands for Java Database Connectivity. It defines how a Java program can communicate with database. This section focuses mainly on JDBC 2.0 API. JDBC API provides two packages they are java.sql and javax.sql . By using JDBC API, you can connect virtually to all the databases, send SQL queries to the database and process the results.
|
|
JDBCBench
In looking to categorize the performance of different databases and JDBC drivers, I found that there were no benchmarks available. I decided to create my own simple benchmark, based on standards from other benchmarks.
|
|
Scale an application from 2 to 3 tiers with JDBC
The Forum application that we created earlier this year is a pretty nifty bulletin-board system, but it needs some work if we want to make it a production-grade application. This month, we'll develop a JDBC communications layer that talks to a simple Microsoft SQL Server 6.5 database, and then build the layer into the server for the discussion forum.
|
|
Performance tuning your JDBC application
The concepts involved with Java, JDBC, and DBMS processing are new to many programmers. As Java becomes more widely used, database access and database applications will become increasingly easy to implement. This document provides some tips on how to obtain the best performance from JDBC applications.
|
|
Use JDBC for industrial-strength performance, Part 2
Although you can create complex applications using the simple and easy-to-use design patterns of the JDBC API, you may gain better performance by allowing a single statement to return multiple ResultSets. In this article, Lennart Jörelid explores the methods of using batch-oriented techniques to acquire multiple ResultSet objects.
|
|
Use JDBC for industrial-strength performance, Part 1
The JDBC API provides three principal methods for calling a database to extract information. System performance and ease of maintenance depend on the usage scenario you choose. Integrating a Java server application with a legacy database system is a nontrivial task; evaluating system-usage scenarios and server-side patterns is important for creating fast, robust application systems.
|
|
Optimizing Database Performance in J2EE Applications
The Java 2 Platform, Enterprise Edition (J2EE), is the platform of choice for implementing scalable and reliable enterprise applications from reusable components. But Java developers building enterprise-class J2EE applications face a quandary.
|
|
Creating Optimized JDBC Applications
While Java databases have become essential for Web applications, developing performance-oriented Java Database Connectivity (JDBC) applications can be challenging. But by following tried-and-true approaches, it is possible to develop and fine-tune JDBC applications to make them run faster, jump higher, and make fewer trips to the database.
|
|
Get disconnected with CachedRowSet
The new CachedRowSet, still in early access release, provides benefits that developers can begin to take advantage of right away. Taylor Cowan demonstrates how you can use a CachedRowSet as the data model for a JavaServer Pages (JSP) entry/edit form.
|
|
Enterprise Java
Connection Strategies in EntityBeans
|
|
Sophisticated Databases
Databases are the bread and butter of virtually any Web application that serves customers, and they are the basis of any material contribution to a business entity. Just as developers have used tools such as Visual Basic to build front ends to databases for traditional client/server applications, Java programmers today use JavaServer Pages (JSP) to create Web-based user interfaces for manipulating data in databases.
|
|
Top Ten Oracle JDBC Tips
The Java Database Connectivity (JDBC) API is a set of interfaces that allow a Java programmer to access a database. The interfaces are implemented by each vendor's set of implementation classes. After several years of working with Oracle's JDBC implementation, I've learned a number of things that you can do to squeeze out the best performance and the most functionality.
|
|
What areas should I focus on for the best performance in a JDBC application?
|
|
Extreme Performance
The performance of J2EE-based applications sometimes doesn't live up to users' expectations. Usually it's impossible to quantify exactly where the bottlenecks are. Many developers spend time searching for articles on the Internet only to find the same old tips about using the synchronized keyword and string concatenation without ever finding information that's useful. This article will help you find the holy grail of Java performance.
|
|
Improved Performance with a Connection Pool
If you have heard anything about Servlets you know that one of the advantages over CGI is that a Servlet can keep information between requests and share common resources. This article describes one common use of this feature, namely a database connection pool.
September 01, 1999
|
|
Making your WebSphere Application Jump Faster and Jump Higher
When creating optimized WebSphere applications that access data on your DB2 database, what kinds of challenges do you face? Creating DB2-enabled WebSphere apps involves the Java Database Connectivity (JDBC) API, which can be a challenge in itself. This article will look at various DB2-enabled applications and offer some guidelines to help your WebSphere applications run more efficiently when they connect to a DB2 database.
|